| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If activecell is not text
How can I pull up a message box if the active cell is not formated as text?
IF activecell.format < text then... ??? Thanks! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
If activecell is not text
Sub Macro1()
Dim r As Range Set r = Selection If Not (Application.IsText(r)) Then MsgBox ("selection is not text") End If End Sub -- Gary's Student "John" wrote: How can I pull up a message box if the active cell is not formated as text? IF activecell.format < text then... ??? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Echo Contents of ActiveCell into a Text box. | Excel Discussion (Misc queries) | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| use of activecell | Excel Programming | |||
| Activecell value | Excel Programming | |||
| how to set activecell? | Excel Programming | |||
Hybrid Mode
