View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben in CA[_2_] Ben in CA[_2_] is offline
external usenet poster
 
Posts: 31
Default Multiply selected cell by a input form

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