| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
#NAME trying to find VB function?
Hi guys. I'm new to excel programming and I wrote a macro by Alt-F11. Now
when I access it from the worksheet I get a #NAME exception. This worksheet is the 4th worksheet in the workbook if that matters. In the editor in the obect dropdown list it says (General) and in the procedure drop-down list it says the name of my function. The procedure shows up when I select (General) or Worksheet in the object dropdown. Do I have to enable VB or something? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#NAME trying to find VB function?
Sounds like it is in a sheet module.
Go to the VBE and do Insert=Module move your code to this module. -- Regards, Tom Ogilvy "fedude" wrote: Hi guys. I'm new to excel programming and I wrote a macro by Alt-F11. Now when I access it from the worksheet I get a #NAME exception. This worksheet is the 4th worksheet in the workbook if that matters. In the editor in the obect dropdown list it says (General) and in the procedure drop-down list it says the name of my function. The procedure shows up when I select (General) or Worksheet in the object dropdown. Do I have to enable VB or something? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
#NAME trying to find VB function?
Thank you. That fixed it!
"fedude" wrote: Hi guys. I'm new to excel programming and I wrote a macro by Alt-F11. Now when I access it from the worksheet I get a #NAME exception. This worksheet is the 4th worksheet in the workbook if that matters. In the editor in the obect dropdown list it says (General) and in the procedure drop-down list it says the name of my function. The procedure shows up when I select (General) or Worksheet in the object dropdown. Do I have to enable VB or something? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Function | Excel Worksheet Functions | |||
| find function | Excel Worksheet Functions | |||
| Find Function | Excel Discussion (Misc queries) | |||
| Find Function via VB | Excel Programming | |||
| backwards find function to find character in a string of text | Excel Programming | |||
Hybrid Mode
