| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to reconcile numbers accounting Harlan Grove code doesn't work for negative numbers | Excel Programming | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Identifying cell types in column using .SpecialCells(xlConstants, xlNumbers) | Excel Programming | |||
![Charlotte E.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
