Seamus2626
asked on
VBA Userform Calculator
Hi,
I am trying to create a calculator which does a couple of things
(1) Shows on entry to the spreadsheet the userform
'Calculator' (Preferably nearcell b2 in sheet Calculator)
When a user clicks the button i would like it to show the listbox (Dropdown Userform) based on the numbers in ColumnA in sheet "Base Rate"
(2) Once the number is selected, i would like it to send the number to cell D3 in sheet Base Rate and then a message box says calculation complete
Can anyone assist with the code?
Thanks
Seamus
Interest-Calculator.xls
I am trying to create a calculator which does a couple of things
(1) Shows on entry to the spreadsheet the userform
'Calculator' (Preferably nearcell b2 in sheet Calculator)
When a user clicks the button i would like it to show the listbox (Dropdown Userform) based on the numbers in ColumnA in sheet "Base Rate"
(2) Once the number is selected, i would like it to send the number to cell D3 in sheet Base Rate and then a message box says calculation complete
Can anyone assist with the code?
Thanks
Seamus
Interest-Calculator.xls
If you really want to do this with code, I can provide, just ask...
ASKER
Hey thanks Zwiekhorst, could you please provide the code, im gonna work more with user forms and may not be able to use balidation lists all the time, so that would be really handy
Thanks
Seamus
Thanks
Seamus
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Zwiekhorst!!
Thats excellent
Cheers,
Seamus
Thats excellent
Cheers,
Seamus
You can go without VBA when you use liast validation on named range...
Look at example..
KR
Eric
Interest-Calculator-1-.xls