Hi guys, I've been trying to create combo boxes in Excel 2002 and have succeeded in creating them with absolutely no knowledge of VB and some basic research on the net...
Here's the problem:
1) All of the 3 combo boxes show ' =EMBED("Forms.ComboBox.1","") '
Shouldn't each box1, box2 and box3 have diff Embeds....???
2) the date function was a bit too frustrating overall! Firstly I've used (in respective date combo boxes code the following:.....
Private Sub ComboBox1_Change()
ComboBox1.Value = Format(ComboBox1.Value, "mmmm -yy")
End Sub
Private Sub ComboBox2_Change()
ComboBox2.Value = Format(ComboBox2.Value, "dd mmmm -yy")
End Sub
Private Sub ComboBox3_Change()
ComboBox3.Value = Format(ComboBox3.Value, "dd/mm/yy")
End Sub
Now this is the only code I've used
without any initial declarations etc of any sort!
Some date calculations work fine and yet some just dont!
eg
date in combo box 2 ( "dd mmmm 'yy" ) format when compared with exactly the same date in another cell ( with dd/mm/yy format) doesn't show as the same date or "true" .... :(
As a result all my date calculations are going haywire!!
PLS help ......
many thanks in anticipation!
Regds
Tom
PS: Also could someone be kind enough to point me in the right direction to creating an icon type , pop up calender in Excel please....