View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Is there a test for an empty string that returns a boolean?

You might look at IsMissing, however with your optional string I'd do it
like this

Private Sub SetOptBut(FontBack As Boolean, PlnCptn As String, _
Optional ElevCptn As String = "dummy")

bMissing = (ElevCptn = "dummy")

change "dummy" to something you know will never be passed

Regards,
Peter T


"Dave F." wrote in message
...
Hi

I'm passing the ElevCptn parameter as Optional:

Private Sub SetOptBut(FontBack As Boolean, PlnCptn As String, Optional
ElevCptn As String)

I want to test to see if the parameter has been included & Enable a
button if it is, & Disable it if is isn't, so I'd like it to return a
boolean.

Something like this:
CboElevation.Enabled = IsEmpty(ElevCptn)

Except that doesn't work because "" isn't an empty string.

Any help is appreciated

Ta
Dave F.