View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Charlotte E.[_2_] Charlotte E.[_2_] is offline
external usenet poster
 
Posts: 70
Default xlConstants to numbers?

In a cell, say "B3", I have one of the VBA xlConstants as written text, say
'xlDialogActivate'.

Is is possible to get this converted into the number of the xlConstant?

I've tried...


MsgBox Evaluate(Range("B3").value)


But with no luck :-(


Any other way to get this done?


TIA,

CE