Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unexpected output while populating a combo box
Hi, I am making a userform in Excel. In the userform, I have a multipage in which on the loading of the form, I would want to see the combo box populate itself. I am using the following code: Code: -------------------- Private Sub MultiPage1_Change() With cbDataType .AddItem ("----- Select Data Type -----") .AddItem ("Text") .AddItem ("Memo") .AddItem ("Number") .AddItem ("Date/Time") .AddItem ("Currency") .AddItem ("AutoNumber") .AddItem ("Yes/No") End With End Sub -------------------- When I do that, what happens is that the combo box does get populated but everytime I switch back and forth between this Page (in which the combo box is placed) and other pages, the list of items multiply. If I switch between the pages thrice, the above items will appear thrice in the combo box. I understand that this is because of the "change" event of the multipage, but then what should I be doing to prevent that from happening? Please help. Regards, Shivboy -- shivboy ------------------------------------------------------------------------ shivboy's Profile: http://www.excelforum.com/member.php...o&userid=35137 View this thread: http://www.excelforum.com/showthread...hreadid=548951 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unexpected output while populating a combo box
Either populate the combobox in the _Initialise event of the form, or use cbDataType.clear in the MultiPage1_Change event before adding in the entries. Col -- colofnature ------------------------------------------------------------------------ colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356 View this thread: http://www.excelforum.com/showthread...hreadid=548951 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unexpected output while populating a combo box
Hey Col, That worked man! Thanks a lot for your help. Thanks ! Peace, Shi -- shivbo ----------------------------------------------------------------------- shivboy's Profile: http://www.excelforum.com/member.php...fo&userid=3513 View this thread: http://www.excelforum.com/showthread.php?threadid=54895 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unexpected #N/A error from INDEX-MATCH combo | Excel Worksheet Functions | |||
Excel VBA Combo Box Populating dependent on other combo box choices | Excel Programming | |||
Populating Combo Boxes | Excel Programming | |||
Populating a combo box | Excel Programming | |||
Populating a Combo Box | Excel Programming |