Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1631
  • Last Modified:

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
0
Seamus2626
Asked:
Seamus2626
  • 3
  • 2
1 Solution
 
Eric ZwiekhorstTSE service engineerCommented:
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 ZwiekhorstTSE service engineerCommented:
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
 
Eric ZwiekhorstTSE service engineerCommented:
Hi Seamus

Please find the example file attached
Interest-Calculator-1---version-.xls
0
 
Seamus2626Author Commented:
Thank you Zwiekhorst!!

Thats excellent

Cheers,
Seamus
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now