Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Verbiage
I have an Inputbox that scans a range of rows in a column and asks for
corrections to cells that do not meet the required cell content. Once a cell is found that does not meet the requirements the user has the opportunity to input the correct data via an Inputbox. On the Inputbox the verbiage is “Please enter a 6 digit value”. Is there a way to include the cell address and column header? Something like “Please enter a 6 digit value in the Accounts column cell N25” or something similar. As always, thank you guys you’re the best. Ron |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Verbiage
You can assign a variable to the cell based on the same criteria that finds
it. You did not specify the method that you are using to locate the errant cell, but if you were using Find, the whatever you set as the find object variable can also be used to identify both the cell address and the column header. Here is and example: Set c = Cells.Find("Flub", LookIn:=xlValues) If Not c Is Nothing Then c.Value = InputBox("Enter correct data for cell " _ & c.Address & " for column Header " & + Cells(1, c.Column)) End If The above is for illustration only, It would probably need some qualification for the Cells reference to avoid runtime errors. But maybe it will give you an idea. "Ron" wrote: I have an Inputbox that scans a range of rows in a column and asks for corrections to cells that do not meet the required cell content. Once a cell is found that does not meet the requirements the user has the opportunity to input the correct data via an Inputbox. On the Inputbox the verbiage is €śPlease enter a 6 digit value€ť. Is there a way to include the cell address and column header? Something like €śPlease enter a 6 digit value in the Accounts column cell N25€ť or something similar. As always, thank you guys youre the best. Ron |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Verbiage
On Apr 17, 4:15*am, Ron wrote:
I have an Inputbox that scans a range of rows in a column and asks for corrections to cells that do not meet the required cell content. *Once a cell is found that does not meet the requirements the user has the opportunity to input the correct data via an Inputbox. *On the Inputbox the verbiage is “Please enter a 6 digit value”. *Is there a way to include the cell address and column header? * Something like “Please enter a 6 digit value in the Accounts column cell N25” or something similar. *As always, thank you guys you’re the best. *Ron try this: "Please enter a 6 digit value in the Accounts column " & ActiveCell.Address |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Verbiage
On Apr 16, 10:39*pm, dk wrote:
On Apr 17, 4:15*am, Ron wrote: I have an Inputbox that scans a range of rows in a column and asks for corrections to cells that do not meet the required cell content. *Once a cell is found that does not meet the requirements the user has the opportunity to input the correct data via an Inputbox. *On the Inputbox the verbiage is “Please enter a 6 digit value”. *Is there a way to include the cell address and column header? * Something like “Please enter a 6 digit value in the Accounts column cell N25” or something similar. *As always, thank you guys you’re the best. *Ron try this: "Please enter a 6 digit value in the Accounts column " & ActiveCell.Address Hi dk, worked great. Thanks for sharing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
InputBox | Excel Programming | |||
How do I add verbiage to a cell that has a hyperlink already | Excel Discussion (Misc queries) | |||
Compare Text in 2 worksheets where verbiage is slightly different | Excel Worksheet Functions | |||
Macro to get rid of "Chart1" Verbiage | Excel Discussion (Misc queries) | |||
Inputbox and Application.InputBox | Excel Programming |