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
Seamus2626Asked:
Who is Participating?
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Hi Seamus

Please find the example file attached
Interest-Calculator-1---version-.xls
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
Dear Seamus,
You can go without VBA when you use liast validation on named range...

Look at example..

KR

Eric
Interest-Calculator-1-.xls
0
 
Eric ZwiekhorstSAP Business ConsultantCommented:
If you really want to do this with code, I can provide, just ask...
0
 
Seamus2626Author Commented:
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
0
 
Seamus2626Author Commented:
Thank you Zwiekhorst!!

Thats excellent

Cheers,
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.