So I total new at VBA. I'm using the Excel 2007 Bible to get started and the information is a bit overwhelming. This is probably a really stupid question to ask but here is my problem.
I have been experimenting with functions. I created a functions using a Select Case Construct.
The function worked perfectly when I typed it in. I saved/closed my workbook and took a break.
I reopened my work book and tried the function again and I receieved an Invalid Name Error.
Thoughts?
Last edited by Davidwebb526; 08-29-2013 at 11:24 AM.
What is the name of your function? How are you calling it?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
I just called it "NumSign" and I'm calling it in the Fx field as "=NumSign()"
First off, the thread title doesn't really comply with Rule 1 of the forum, so technically I probably shouldn't answer, but this is a gimme, and I really don't want to discourage you from asking questions on the forums.
Check to see if macros are enabled... Custom functions are stored the same way macros are, so they need to be abled when opening up excel.
Additionally, it also matters where you stored the function. If you created a personal.xlsm file, if you open up a second instance of excel, it may not be able to read those custom functions due to it already being opened by the first instance (basically, if you click the excel executable twice, it'll open two windows of excel, rather than many workbooks within one big excel window).
Lastly, a tip when starting to work in VBA... just check out a lot of the posts on these forums for ideas for the code itself. A lot of the gurus here have some ridiculous VBA experience, and write some ridiculously complex, compact functions that'll impress you.
Going for Guru! Click the Star to the bottom left of this post if I helped!
First of all I apologize for my indescretion with rule 1. Most forums usually have the same generic rules with regards to language and harassment. I'll be sure to follow protocol with future threads.
My macros are enabled and my module where my original code was input, open with the workbook. So it would appear that the location is fine.
David,
Please amend your thread title as suggested by Miraun before others can proceed to help you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
I believe functions created in the VBE have to be called through code. Such as:e/ My mistake arlu, I hit reply before I saw your request.
Please Login or Register to view this content.
Last edited by Solus Rankin; 08-29-2013 at 11:24 AM.
Nope. You can call them from cells as long as they are in a normal module.Originally Posted by XeRo Solus
Remember what the dormouse said
Feed your head
At this point, probably best to attach a sample workbook using the advanced posting functions of the forum so we can take a full look at what's happening.
I knew I shouldn't have been so certain.Nope. You can call them from cells as long as they are in a normal module.
Good news and bad news.
Good news-Problem solved! I needed to create a trusted location and save my workbook there.
Bad news-Basically it meant my macros were not being enabled so I feel like dummy.
Thanks everyone.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks