jimmybjames
New Member
- Joined
- Mar 5, 2010
- Messages
- 1
Hello, I'm using Office 2007 on XP.
I am using drop down lists to control the contents of cells. Based on what the user chooses from the drop down menu I would like the cell to either have a value, a formula, or a user entered value put in it. Of course if I put a formula into the cell and the user put their own value in it will replace the formula that was there. Is there anything I could use to, depending on what is chosen from the drop down list, change what is entered in a cell?
I know macros can easily do this but my boss wants this to be sent to our customers and the macros will be blocked and I would like it to be able to work as soon as the open the workbook.
I am using drop down lists to control the contents of cells. Based on what the user chooses from the drop down menu I would like the cell to either have a value, a formula, or a user entered value put in it. Of course if I put a formula into the cell and the user put their own value in it will replace the formula that was there. Is there anything I could use to, depending on what is chosen from the drop down list, change what is entered in a cell?
I know macros can easily do this but my boss wants this to be sent to our customers and the macros will be blocked and I would like it to be able to work as soon as the open the workbook.
