| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
combo box in a user form
I have created a form containing a combo box using the following code:
With cmbMonth ..AddItem "Jan" ..AddItem "Feb" ..AddItem "Mar" ..AddItem "Apr" ..AddItem "May" ..AddItem "June" ..AddItem "July" ..AddItem "Aug" ..AddItem "Sept" ..AddItem "Oct" ..AddItem "Nov" ..AddItem "Dec" It works great except once an entry is made, the contents in the form fields cleared, and another entry is to be made, the combo multiplies showing a doubled list of months. How can I keep these from doubling. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combo box in a user form
Add the ".clear" after the first line.
With cmbMonth .Clear .Additem "Jan" .... Regards, Edwin Tam http://www.vonixx.com "juliejg1" wrote: I have created a form containing a combo box using the following code: With cmbMonth .AddItem "Jan" .AddItem "Feb" .AddItem "Mar" .AddItem "Apr" .AddItem "May" .AddItem "June" .AddItem "July" .AddItem "Aug" .AddItem "Sept" .AddItem "Oct" .AddItem "Nov" .AddItem "Dec" It works great except once an entry is made, the contents in the form fields cleared, and another entry is to be made, the combo multiplies showing a doubled list of months. How can I keep these from doubling. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combo box in a user form
When I do this I get the following error message:
Complie error: Expected Function or variable "Edwin Tam" wrote: Add the ".clear" after the first line. With cmbMonth .Clear .Additem "Jan" .... Regards, Edwin Tam http://www.vonixx.com "juliejg1" wrote: I have created a form containing a combo box using the following code: With cmbMonth .AddItem "Jan" .AddItem "Feb" .AddItem "Mar" .AddItem "Apr" .AddItem "May" .AddItem "June" .AddItem "July" .AddItem "Aug" .AddItem "Sept" .AddItem "Oct" .AddItem "Nov" .AddItem "Dec" It works great except once an entry is made, the contents in the form fields cleared, and another entry is to be made, the combo multiplies showing a doubled list of months. How can I keep these from doubling. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
combo box in a user form
It worked after I tried it again..thanks for the help! "Edwin Tam" wrote: Add the ".clear" after the first line. With cmbMonth .Clear .Additem "Jan" .... Regards, Edwin Tam http://www.vonixx.com "juliejg1" wrote: I have created a form containing a combo box using the following code: With cmbMonth .AddItem "Jan" .AddItem "Feb" .AddItem "Mar" .AddItem "Apr" .AddItem "May" .AddItem "June" .AddItem "July" .AddItem "Aug" .AddItem "Sept" .AddItem "Oct" .AddItem "Nov" .AddItem "Dec" It works great except once an entry is made, the contents in the form fields cleared, and another entry is to be made, the combo multiplies showing a doubled list of months. How can I keep these from doubling. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding items to a combo box on a user form | Excel Discussion (Misc queries) | |||
| Excel User form with 4 Combo Boxes | Excel Programming | |||
| Can't seem to get Combo Box on User Form | Excel Programming | |||
| Patrick -- 424 Combo Box User Form | Excel Programming | |||
| Run Time Error 424 Combo Box User Form | Excel Programming | |||
Hybrid Mode
