| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
control box
In an active X control box - is there any way to only allow the list that its
linked to. meaning I linked to a range - but you can still type in whatever you want - can I stop this ? Thanks, Yosef |
|
#2
|
|||
|
|||
|
Yes, change the Style property to 2 - fmStyleDropDownList
-- Regards, Juan Pablo González Excel MVP "ynissel" wrote in message ... In an active X control box - is there any way to only allow the list that its linked to. meaning I linked to a range - but you can still type in whatever you want - can I stop this ? Thanks, Yosef |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
| Variable control tip text | Excel Discussion (Misc queries) | |||
| calendar control - formatting | Excel Discussion (Misc queries) | |||
| Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
| Copying list-box control | Excel Discussion (Misc queries) | |||
Linear Mode
