Hi Guys,
I am trying to load date in small textboxes via Vlookup when a Milestone in the ComboBox is chosen I, however get a runtime 1004 error when trying to do this.
Can anybody help out.
When Milstone X is picked then fill out textbox one-to-four from topdown.
and vice-verca, when client is picked and textbox is populated->then get the ability to change the value for each independent elements per milestone :0
I have attached the workbook and believe I am almost there.
You haven't declared GetRange anywhere that I can see.
Rory
Yes you are absolutely right. I have fixed that and set the range as a global range.
I, however still have the issue.
Updated workbook attached
Please Login or Register to view this content.
Last edited by bakerman2; 03-02-2020 at 05:32 AM.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Hi Bakerman2,
Wow that was an easy way and really clean.
Thanks a lot.
You made GetRange one column and still didn't declare it properly. You need to add
to the top of the userform code above all procedures. Then in the Initialize event it needs to be set to the entire range you need to use (and bear in mind when assigning the column numbers you want back that your first two columns are merged).Please Login or Register to view this content.
Without going any further get rid of all your merged cells.
They are the "kiss of death" for VBA.
There are plenty of articles on the 'web' condemning their use.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks