SameerMirza
asked on
Excel vba code test
Hi guys,
I have an interview in couple of days. Not an expert on VBA but I do some stuff :)
Can any one please post some good code base tests
Like picking errors etc. I hop you can understand what I am looking for :)
Kind regards
I have an interview in couple of days. Not an expert on VBA but I do some stuff :)
Can any one please post some good code base tests
Like picking errors etc. I hop you can understand what I am looking for :)
Kind regards
It's not clear what you want here! If you're looking for some specific code, I suggest that you make a search here on Excel Zone by some keywords that are relevant to what you're looking for like "VBA keyword1" and I'm sure that you will find that here.
ASKER
interview questions ..
code based questions to check your logic and syntax skills
code based questions to check your logic and syntax skills
ASKER
I am sure there owuld be some online but was wondering if its written by any of experts here or if any could provide me with good source etc
SameerMirza,
I know what you want but I haven't seen anything like it. You want to take some practice exams while you are refining your VBA skills in preparation for the interview.
I think your best bet is to do searches on Experts Exchange. For example, search for "error handling" in the VB Classic and Excel zones and you will find a bucketful of random questions and answers on that subject. The cool thing is that they are real world examples and not out of a text book. This is actually how most of the experts on EE have become so good - we try to answer questions every day and we see solutions that other experts post as we try to solve them ourselves. It's a great way to learn.
Kevin
I know what you want but I haven't seen anything like it. You want to take some practice exams while you are refining your VBA skills in preparation for the interview.
I think your best bet is to do searches on Experts Exchange. For example, search for "error handling" in the VB Classic and Excel zones and you will find a bucketful of random questions and answers on that subject. The cool thing is that they are real world examples and not out of a text book. This is actually how most of the experts on EE have become so good - we try to answer questions every day and we see solutions that other experts post as we try to solve them ourselves. It's a great way to learn.
Kevin
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks.
@Rob,
when you link to a site, you can just type the address like http://www.google.com -- the EE site software will create the link automatically.
You don't need to use the link code or URL tags. In fact, if you use URL tags, make sure that the tags are properly formed. I've corrected the links in your post above.
See this link, created without link (URL) tags http://www.google.com <-- this one works
In the edit window it looks like this:
See this link, created with mal-formed link (URL) tags http://www.google.com <-- this one does not work.
In the edit window it looks like this:
You only need to use the link button if you want to link friendly text to a URL. Like this. In the edit window it looks like this:
when you link to a site, you can just type the address like http://www.google.com -- the EE site software will create the link automatically.
You don't need to use the link code or URL tags. In fact, if you use URL tags, make sure that the tags are properly formed. I've corrected the links in your post above.
See this link, created without link (URL) tags http://www.google.com <-- this one works
In the edit window it looks like this:
See this link, created without link (URL) tags http://www.google.com <-- this one works
See this link, created with mal-formed link (URL) tags http://www.google.com <-- this one does not work.
In the edit window it looks like this:
See this link, created with mal-formed link (URL) tags [url="http://"]http://www.google.com[/url] <-- this one does not work.
You only need to use the link button if you want to link friendly text to a URL. Like this. In the edit window it looks like this:
link friendly text to a URL. Like [url="http://www.google.com"]this[/url].
cheers, teylyn
@Rob, I took the test and left a comment in the DDoE blog. Thanks for the link!!
hi Teylyn,
Thanks for the tips.
Hmmm, I've probably left a trail of mal-formed URL's scattered throughout all many of my EE posts!
I thought the "friendly text" section was optional & have frequently just clicked through it - perhaps I was on auto-pilot & pasting into the wrong section. Anyway, I'll try to rely on the EE site making the conversion. Anything to save a couple of point & clicks or [shift + tabs] must be good ;-)
There are probably a fair few tests out there, but I saw the link for that one on DDoE and the various people making comments plus the content of the comments made me think "I'll give it a go". It was a while ago when I did the test & I think I got 80-ish as well. There were definitely some ambiguous questions in the mix.
Rob
Thanks for the tips.
Hmmm, I've probably left a trail of mal-formed URL's scattered throughout all many of my EE posts!
I thought the "friendly text" section was optional & have frequently just clicked through it - perhaps I was on auto-pilot & pasting into the wrong section. Anyway, I'll try to rely on the EE site making the conversion. Anything to save a couple of point & clicks or [shift + tabs] must be good ;-)
There are probably a fair few tests out there, but I saw the link for that one on DDoE and the various people making comments plus the content of the comments made me think "I'll give it a go". It was a while ago when I did the test & I think I got 80-ish as well. There were definitely some ambiguous questions in the mix.
Rob
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.