Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all,
Hope everyone that reads this is fine and the person who solves my problem lives to at least 93 years of age. Problem: I have a Textbox within a Userform with which I want the user to input a valid spreadsheet cell address. At the moment, the code that I have written to check the value within the Textbox looks to see if the first character is not numeric and the last character is numeric. The massive hole in this test is that someone could input 'DAVID3' and it would pass. Is there a way to check for a valid spreadsheet cell address? Regards, David Seebaran. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Validate entry based on another cell value | Excel Discussion (Misc queries) | |||
Validate date entry in a text box. | Excel Discussion (Misc queries) | |||
validate duplicate entry in a column | Excel Discussion (Misc queries) | |||
Validate Email address entry | Excel Discussion (Misc queries) | |||
Validate in WS to prevent dual data entry | Excel Worksheet Functions |