| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Info
Hi everyone. Somehow I think I should know this but the answer is
just not stepping up. In Excel for example I know to use this formula for finding out if a cell has data in it. =IF(F18<"","Yes","No") What is the syntax for doing this VBA? if cboDepartment (HAS a value) then do this, otherwise do this. Thanks in advance! -LT |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Info
Hi LT,
One way: If Not IsEmpty(Range("A1")) Then ;do something End If --- Regards, Norman "LT" wrote in message oups.com... Hi everyone. Somehow I think I should know this but the answer is just not stepping up. In Excel for example I know to use this formula for finding out if a cell has data in it. =IF(F18<"","Yes","No") What is the syntax for doing this VBA? if cboDepartment (HAS a value) then do this, otherwise do this. Thanks in advance! -LT |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Info
Sub Macro1()
If cboDepartment.Value = "" Then MsgBox "Has no Value Exit Macro..." Exit Sub Else MsgBox "Has Value Run Macro..." End If End Sub "LT" wrote: Hi everyone. Somehow I think I should know this but the answer is just not stepping up. In Excel for example I know to use this formula for finding out if a cell has data in it. =IF(F18<"","Yes","No") What is the syntax for doing this VBA? if cboDepartment (HAS a value) then do this, otherwise do this. Thanks in advance! -LT |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
VBA Info
On May 16, 11:46 am, "Norman Jones"
wrote: Hi LT, One way: If Not IsEmpty(Range("A1")) Then ;do something End If --- Regards, Norman "LT" wrote in message oups.com... Hi everyone. Somehow I think I should know this but the answer is just not stepping up. In Excel for example I know to use this formula for finding out if a cell has data in it. =IF(F18<"","Yes","No") What is the syntax for doing this VBA? if cboDepartment (HAS a value) then do this, otherwise do this. Thanks in advance! -LT- Hide quoted text - - Show quoted text - Thanks for the reply Mike and Norman! Much appreciated! -LT |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Move cell info and info in range of cells on new entry | Excel Discussion (Misc queries) | |||
| Copied info from Excel worksheet, but pasted info won't work in fo | Excel Discussion (Misc queries) | |||
| Copy info into empty cells below info, until finds cell with new d | Excel Discussion (Misc queries) | |||
| need help w/ macro prompting with info and pasting the info based on user input | Excel Programming | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
