Good day,
Trying to figure our how to do the following:
Userform:
My list is based on a control sheet that I have but I need that if Combobox 2 = Case 0 then to make my Combobox3.Enable = False and if not Case 0 then Combobox3.Enable = True.
Please Login or Register to view this content.
Is this possible or I would need a (Combobox2_Change) If / Else /End If function?
Click the star icon in the lower left part of the contributor's post and add Reputation if we have helped you.
Hi,
Before we can answer your question, we need to know where the following values come from and if they are local or global in scope:
a. list1
b. list2
c. list3
d. arrData
You may need to add 'Option Explicit' to your module. To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. dim i as Integer).
http://www.cpearson.com/excel/DeclaringVariables.aspx
Lewis
Just put the line
at the beginning of the ComboBox2_Change event.Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Thank you Mike...works great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks