Default value in a combo box

garyd1234

Board Regular
Joined
Apr 17, 2003
Messages
103
Hi,
I have a combo box that gets its row source from a table of data. I also want the default value to say New Entry but I put that in the default value property and it doesn/'t show up. I tried putting in code too
combo94.defaultvalue= "New Entry". It won't show up. Is there another property needs set. I tried Limit to List =Yes and No and it won't show up??

\Thanks
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi garyd1234

As far as I can see, there is no such property for the ComboBox as "DefaultValue". To add the words "New Entry" to your Combobox, just add the line ComboBox94.Value = "New Entry" to the last row of your code and that line will appear on the first row of your combobox. However, when you choose a new value, the "New Entry" value will dissapear. It will not become part of the list. You need the AddItem method for that.

anvil19
:eek:
 
Upvote 0

Forum statistics

Threads
1,221,614
Messages
6,160,839
Members
451,673
Latest member
wella86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top