JohnSearcy
Board Regular
- Joined
- Feb 6, 2006
- Messages
- 101
Hi -
Just a simple question......
I want to set the RowSource for the ComboBox on the UserForm in the actual Properties window in the VBA editor and I cannot find the proper way. Always getting the Invalid Property value message. I know how to do it through VBA and it would be simple and work but this is ticking me off. I have tried numerous ways that I have found on the web and nothing works. A recent example of one of the MANY ways I tried:
"=Sheet8!$A$1:$A$104"
I had the sheet named LINING STOCK # but changed it to try it as Sheet8. Still wouldn't work. I would like the sheet to be named LINING STOCK #. It has to be something simple that I have not tried or I may be trying to do something that there is no solution for. Using Office 365 at work. Suggestions?
Thank you,
John
Just a simple question......
I want to set the RowSource for the ComboBox on the UserForm in the actual Properties window in the VBA editor and I cannot find the proper way. Always getting the Invalid Property value message. I know how to do it through VBA and it would be simple and work but this is ticking me off. I have tried numerous ways that I have found on the web and nothing works. A recent example of one of the MANY ways I tried:
"=Sheet8!$A$1:$A$104"
I had the sheet named LINING STOCK # but changed it to try it as Sheet8. Still wouldn't work. I would like the sheet to be named LINING STOCK #. It has to be something simple that I have not tried or I may be trying to do something that there is no solution for. Using Office 365 at work. Suggestions?
Thank you,
John