Search : in
By :

Query on Excel macro - Asking a value in macr

Last answer on Oct 15, 2008 10:33:44 am BST sunil, on Oct 15, 2008 6:27:39 am BST 
 Report this message to moderators

Hello,
I would like to know how to write a macro that should ask in during the run, a particular value and than consider that value in its run downstream.
Everytime when I run that macro It should ask me to reenter that value and it should come a a popper, once given the value and clicked ok, it should use that value and run the rest of the macro.
Please help
Regards
Sunil

Configuration: Windows XP
Internet Explorer 6.0

Best answers for « Query on Excel macro Asking a value in macr » in :
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Excel – Macro to detect and hide blank rows ShowExcel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...

1

 jmets111, on Oct 15, 2008 10:33:44 am BST

Hello,

here is a link where you will get the help for the macro:

http://www.techonthenet.com/excel/macros/index.php

Reply to jmets111