ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Combobox (https://www.excelbanter.com/excel-programming/291825-combobox.html)

Francis Ang

Combobox
 
Hello,

I am very impressed with the way questions are being answered by you nice people out there. So I have decided to post a question myself and hope to receive an answer.

I have 15 comboboxes on a userform and want to set the "Enabled" properties to false using the loop command. But when I run the macro I get the message "member not found" Can anyone help me with this problem.

Thanks in advance.

Bob Kilmer[_2_]

Combobox
 
Francis,
See my response to a recent message whose subject is "changing selected
label on userform w/ a variable" for ideas about accessing userform controls
in a loop.

Bob

"Francis Ang" wrote in message
...
Hello,

I am very impressed with the way questions are being answered by you nice

people out there. So I have decided to post a question myself and hope to
receive an answer.

I have 15 comboboxes on a userform and want to set the "Enabled"

properties to false using the loop command. But when I run the macro I get
the message "member not found" Can anyone help me with this problem.

Thanks in advance.




Francis Ang

Combobox
 
Thanks alot Bob. Your suggestions work perfectly for me. Thanks again.


All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com