View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Balazee
 
Posts: n/a
Default How to Add Restrictions to ComboBox...???

Hi Paul,

I'm trying to restrict user to selection available in the combobox. For
example: if the dropdown selection has options A,B,C,D...Then the user
should be able to access only these selections. I have created a
userform on the VBA.........

Thanks for the help
....

Balazeee

Paul Mathews wrote:
Balazee, what is it that you are attempting to restrict your users access to?
Data in a sheet other than the one the combo box is on? Is your combo box a
Forms control in a worksheet or a control on a VBA form? Might be worthwhile
to provide a bit more detail so that we can figure out how to help.

"Balazee" wrote:

Hello,

I'm relatively new to VBA.

My problem is I have created a combo box and I want the user to be
restricted to the drop down selection only.

Any help is appreciated...

Thanks...

Balaji..