| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refer to customproperty by name?
Hi everybody,
is there something wrong with this code or is something wrong with Excel? 'ActiveSheet.CustomProperties.Add Name:="x", Value:=1 ' ok MsgBox ActiveSheet.CustomProperties("x").Value ' Type mismatch MsgBox ActiveSheet.CustomProperties(1).Value ' ok In Word I can refer to a customdocumentproperty by name. MsgBox ActiveDocument.CustomDocumentProperties("x").Value ' ok -- Greetings from Bavaria, Germany Helmut Weber, MVP WordVBA "red.sys" & chr(64) & "t-online.de" Word 2002, Windows 2000 (german versions) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I refer to a row | New Users to Excel | |||
| How to refer a name in VBA | Excel Discussion (Misc queries) | |||
| Refer to value | Excel Discussion (Misc queries) | |||
| refer indirectly to Name | Excel Worksheet Functions | |||
| refer | Excel Discussion (Misc queries) | |||
![Helmut Weber[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
