VBA On & Off Button

scoste

New member
Joined
Jan 23, 2014
Messages
4
Reaction score
0
Points
0
Hello Excel Universe!

I am beginning to learn some VBA on my spare time and was looking for some help on what I need to do in order to make an on/off button on the attached excel doc.

Essentially I would like to have a visual button to click either on or off within the expenses to trigger a formula when on to multiply the C15 - C24 cells to either the number of units or market value or annual income. And if off then the user can input the numbers manually.

Any ideas on where to start or would this be a quick program someone can be so kind in writing for me?
 

Attachments

  • Investor MF ProForma.xlsx
    26.5 KB · Views: 15

patel

New member
Joined
Feb 20, 2014
Messages
60
Reaction score
0
Points
0
Location
Italy
Excel Version(s)
2010
I did not understand what you want, can you explain in other words ?
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,942
Reaction score
0
Points
36
Excel Version(s)
O365
Hoiw do you know whether the formula should use number of units or market value or annual income, and where do these values come from?
 

scoste

New member
Joined
Jan 23, 2014
Messages
4
Reaction score
0
Points
0
Thank you both for the reply, for this worksheet I would like to make it very simple for clients to use this workbook to either enter the data manually for expenses which would be column I, row 15-32 OR be able to estimate by updating the data in column C, row 15-24 which would either multiply a percentage (C15 & C17) by the annual income and multiply the number of units (B4) to cells (C16, C18-C24). All formulas would be located in I15-I24.

These values would be estimates from the clients, same with the units & market value. They would be looking at a potential asset and determining the numbers on their own level of knowledge.

Does this help?
 
Top