combobox property

irresistible007

Board Regular
Joined
Nov 24, 2005
Messages
173
On my sheet there is a logon form where users names are on a combo box... prob is that when i click the combobox (not dropdown arrow) it allows me to type in which i want to restrict... Just like combos on webpages acts

which property to be used?
 

Some videos you may like

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
If you set the Style property to fmStyleDropDownList the dropdown list will appear when the user clicks in the edit box and they won't be able to enter anything that's not in the list.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,038
Messages
5,545,672
Members
410,697
Latest member
srishtijain0708
Top