Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I need a macro that I can assign to a form button that will multiply the value in the selected cell by a percentage entered in an input message box. Basically, I want to be able to select a cell with a number in it, I press this form button with a macro, and then it gives me an input message box - I enter 80 for 80% - and it multiplies the current value by 0.8 and replaces the previous value with that value. (Because for the end users, most cells will be locked and protected, I need an easy way to do this with a macro.) Does anyone know how to make a macro that will do this? Thanks in advance! I really appreciate your replies! Ben |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically input a symbol in a selected cell | Excel Discussion (Misc queries) | |||
Position a user form next to selected cell | Excel Programming | |||
Code to Query SQL Server with a parameter value (entered into an Input Box), and have that value also display in a selected cell on a worksheet | Excel Programming | |||
code to input date after diff. cell selected | Excel Programming | |||
Setting up a form to input into selected worksheet | Excel Discussion (Misc queries) |