totalnatal
New Member
- Joined
- Jun 9, 2010
- Messages
- 33
Hi,
I have a workbook (wkbk A let's call it) with a VBA macro that runs automatically to grab some data from wkbk B.
The macro is designed to open wkbk B, on the userform select "London" from a drop down menu, click on the "OK" button on the user form, press some other button to refresh data, copy paste data of wkbk B and close wkbk B without saving.
I have everything working, except the part where I open wkbk B and then the userform comes up but I do not know what to write in my VBA to select "london" from the drop down menu and click ok.
I've tried to record the macro but it comes up as blank essentially.
Any ideas ? Thanks a lot guys.
I have a workbook (wkbk A let's call it) with a VBA macro that runs automatically to grab some data from wkbk B.
The macro is designed to open wkbk B, on the userform select "London" from a drop down menu, click on the "OK" button on the user form, press some other button to refresh data, copy paste data of wkbk B and close wkbk B without saving.
I have everything working, except the part where I open wkbk B and then the userform comes up but I do not know what to write in my VBA to select "london" from the drop down menu and click ok.
I've tried to record the macro but it comes up as blank essentially.
Any ideas ? Thanks a lot guys.