Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to mark an item selected in the Excel VBA Form?
I made a combobox in a VBA form and I want the user to select only
items from the list but the problem is the default selected item it shows blank and allows user to add his input into it. Kindly suggest a solution .I think If I give a default selected value then the problem will be solved , but how to give the default value? Regards Divya |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to mark an item selected in the Excel VBA Form?
Hi Divya,
try this with just a combobox on the form Private Sub UserForm_Initialize() ComboBox1.List = Array("first", "second", "third") ComboBox1.ListIndex = 1 ' ie 1 is 2nd item End Sub See ListIndex in help Regards, Peter T "divya" wrote in message oups.com... I made a combobox in a VBA form and I want the user to select only items from the list but the problem is the default selected item it shows blank and allows user to add his input into it. Kindly suggest a solution .I think If I give a default selected value then the problem will be solved , but how to give the default value? Regards Divya |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
chek mark in menu item | Excel Programming | |||
How do I put a check mark box in an excel document form? | Excel Discussion (Misc queries) | |||
Menu Item check mark?? | Excel Programming | |||
How do I tell Excel to take a selected item and copy it to anothe. | Excel Worksheet Functions | |||
How do I mark an item as paid so it is not included in a column t. | Excel Worksheet Functions |