View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dk[_2_] dk[_2_] is offline
external usenet poster
 
Posts: 21
Default 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