| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List all TextBox on a sheet
Hi all,
I have 10 TextBox and a command button on an Excel Sheet I don't want to do this in my code... if IsNumeric(TextBox1.Value) and IsNumeric(TextBox2.Value) etc.... What I want to do is something like that : For Each Component in Components if (Component is TextBox) and IsNumeric(Component.Value) then MsgBox Component.Name end if Next Is this possible ? Any examples ? Thanks+ACE- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link a textbox on a sheet to a cell?! | Excel Discussion (Misc queries) | |||
| Textbox changes position on a copied excel-sheet | Excel Discussion (Misc queries) | |||
| Textbox on excel sheet do not update with VBA | Excel Programming | |||
| new line at sheet textbox | Excel Programming | |||
| Accessing a textbox on a sheet.... | Excel Programming | |||
Threaded Mode
