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

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

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

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