Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with interrupt for user input
We have many downloads to reformat into our SAP upload format. I have a
column that contains "errors/omissions" that I would like the macro to process down the column and when a cell is empty or wrong that it would pop up a form or box that the user can input the correct information then the macro would populate that cell and continue down the column. Is something like this possible to do? Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with interrupt for user input
Valerie-
Check the VBA help file for "InputBox Function" - it will do exactly what you need, and you can use the prompt to provide any additional information the user needs, such as the row or other contents from that row. HTH, Keith "Valerie" wrote: We have many downloads to reformat into our SAP upload format. I have a column that contains "errors/omissions" that I would like the macro to process down the column and when a cell is empty or wrong that it would pop up a form or box that the user can input the correct information then the macro would populate that cell and continue down the column. Is something like this possible to do? Thanks in advance for your help! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro with interrupt for user input
Thank you. It's taken me awhile to get it to work like I needed, but I
finally got it! "ker_01" wrote: Valerie- Check the VBA help file for "InputBox Function" - it will do exactly what you need, and you can use the prompt to provide any additional information the user needs, such as the row or other contents from that row. HTH, Keith "Valerie" wrote: We have many downloads to reformat into our SAP upload format. I have a column that contains "errors/omissions" that I would like the macro to process down the column and when a cell is empty or wrong that it would pop up a form or box that the user can input the correct information then the macro would populate that cell and continue down the column. Is something like this possible to do? Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pause a macro for user input | Excel Programming | |||
close application when interrupt by user | Excel Programming | |||
Runtime error 18 user interrupt occured on some Computers | Excel Programming | |||
Pausing a macro for user input | Excel Programming | |||
how to prevent user to interrupt macro | Excel Programming |