Guys - On Saturday 01 Oct it will be a year to the day since I joined the forum!!!
Wow - how time has flown, and not one of my threads in the bad thread section and not one infraction! yeyyy
In that time i've learnt something about excel and met some great folks!
So on sat i'll open a Black Sheep, none of that Canadian Ally Kat stuff, and say cheers to EF!!!
Do I get something from Roy?
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
An infraction?
Remember what the dormouse said
Feed your head
I can give you some.. Anyone else?
A free membership for another year!
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Unfortunately not a one-liner:
Please Login or Register to view this content.
Is it sad if you can read that without running the code?
Time for holidays.....
lol -
I couldn't read it without running it.............will need a couple more years here before I can do that!
No candle?
I think you might be right there!Originally Posted by snb
Many happy conflabulations to you!!!
I'm so ashamed
Mine start at 4:00pm today
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Hi - may I ask what the j serves for in For j and then (Choose(j
Thanks
You may, but it's 1 day too late: in your first year you are allowed to put this kind of questions, after your first anniversary you can only answer those (it's a mod's switch).
It's OK - the 1 year is up tomorrow.
ok - its decided that i'm still within the asking q's threshold and the answer is ..... ? pretty please with a sprinkling of 100's and 1000's
It's a loop variable that increments from 1 to 21 with each iteration of the loop.
Blake 7,
Happy forum birthday! May it be filled with excellence!
... Sorry, couldn't help myself
~tigeravatar
Congrats on your 1 year, Blake.
Will you be changing your avatar from Liberator to Scorpio to mark this event?
No,
Scorpio's' interior was designed by much less know Roger Cann whereas The liberator's interior was designed by Gok Wan! How to teleport n a k e d
scorpio looks like "she" may have been born a "Steve" and Jet - well, i'd jump into her cockpit any day!
She did used to brighten up Saturday evenings...
Wikipedia is calling you a liar (it also spilled your pint and looked at your bird).
Damn those at wiki and thier Blasphemy.........
I probably won't be online much tomorrow.. so I will bid you happy anniversary now
Cheers... have a Caffrey's on me
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
In case you want to relive your first tentative steps:
http://www.excelforum.com/excel-gene...ting-tool.html
Dom
who are you? micheal aspel..............
it was polite and courteous ! I was scared and intimidated!! I tried my best ! you know, i STILL dont understand what DO did!!
thanks for bringing that to peoples attn though Dom !! nice one, remind me to send you a handgrenade for xmas!!!!
Last edited by Blake 7; 09-30-2011 at 09:47 AM.
Very few people do
Dom
Nobody ever does (apart from DDL and NBVC)
You are being modest - DO has mentioned that he has run things past you before!Nobody ever does (apart from DDL and NBVC)
Yeah, generally what beer to buy
Dom
Scorpio scares the be-jangles out of me. She could break me!
If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.
---Keep on Coding in the Free World---
I would definitely have to agree
That had me thinking about my first post so I went to Advanced Search> Chemistb >Find threads started by User
Alas it only goes back 5 years and I started in '04.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Don't expect an accurate reply to this from RS, Darren. He's far too modest to admit that he's being modest.
Last edited by Colin Legg; 09-30-2011 at 10:35 AM.
Code, maybe. Any formulas beyond A1+B1 leave me puzzled.
Who is Darren? - I dont want my colleagues to discover the fountain of my knowledge!
Yes, the Excel work I did for the blood transfusion service went badly wrong after a mix-up over terminology.
Those poor, poor people.
@Andrew-R, that made me laugh out loud at work, haha
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
LoL Andrew
First off you should make sure you never write rubbish code like that.
Any decent coder knows you should ALWAYS declare your variables, and give them meaningful names. Choose was wasteful, a=n array of values and a loop that picks from the array is better. Furthermore, anyone who has any empathy for their user would not inflict that many horrific MsgBox statements on them, they would better give up a nice user form with an aesthetic picture background, with a label that builds up the message in a timed loop, wait for a few seconds with the full message, then fade away independently.
Come on guys, there are standards to preserve.
I second that Bob, my mouse did get very upset that I hit him so many times in quick succession!
Not to mention my arthritis.
I... Uh... Took this challenge as practice and things got out of hand. For some insane reason I set myself the challenge of not uploading a workbook, instead have all of your requirements in a single sub. The problem, as I quickly found, was that you said "user form" and "fade away independantly". As you see from the code below, these were tall orders. If anyone sees a better way to do this, I would love to see it.
Please Login or Register to view this content.
P.S. You need to have the reference "Microsoft Visual Basic for Applications Extensibility X.X" activated in the VBE.
Last edited by Whizbang; 10-03-2011 at 04:47 PM.
Hiya - im getting a "user defined type not defined error" on this line
I was so excited!!
lblNewLabel As MSForms.Label
You need to activate the "Microsoft Visual Basic for Applications Extensibility X.X" reference.
In the VBE, go to "Tools" -> "References" and check that reference (It is all alphabetical, so you'll need to scroll pretty far down), then click "Ok".
***Edit***
Oops. And the "Microsof Forms 2.0 Object Library" reference.
Last edited by Whizbang; 10-03-2011 at 03:41 PM.
I could find this
Microsoft Visual Basic For Applications Extensibility 5.3.
but not xx
That is what you want. The X.X was just because the number may be different depending on your version of Excel.
Ahhhhhhhhhh doh --- silly me - i'll get this thread in the bad threads thread at this rate. I'll have another crack and get back to you
WOW Dude - YOU ARE A WHIZZBANG! amazing!!!
Like being polite and congratulate someone in a thread that was started because of a member's 'anniversary'.Come on guys, there are standards to preserve.
Whizbang...
I activated the Applications Extensibility.... but I am still getting the error:
lblNewLabel As MSForms.Label
I see that I have Microsoft Forms 12.0 object library activated. But no 2.0... Any help...
I've never heard of an msforms 12 library - are you sure about that? If you insert a userform, you should get the forms2 library referenced.
Where's the fading away? All I can see is an unload? Also, Bob didn't actually say you had to create the form in code.
Hi RS,
Please see attached. My VB knowledge is nill so I just tried to follow the instructions.
Cheers-
Inayat
hi inyat - in the developer tab click macro security > in macro settings make sure that "trust access to the VBA project object model is checked
That's the Office 12 library, not the Microsoft Forms 2 library, which is the one you need.
@Blake... I checked that... Still it is giving the same error
@RS... I can not see the Microsoft Forms 2 Library in Reference... Do i need to look anywhere else... As I said, I have zero knowledge in VBA...
As I said, insert a userform and the reference will be added for you. (You can then delete the form)
Here are instructions in the case of missing ms forms 2.0 object library
http://support.microsoft.com/kb/208218
Thanks RS... Works perfectly now...
Thanks Blake....
Why thank you MR rs. You just can't get the staff nowadays!Where's the fading away? All I can see is an unload? Also, Bob didn't actually say you had to create the form in code.
Hopefully this is more to your liking, Sir (shamelessly borrowed from VBAX):
No references required but you do need trusted access to the VBProject.Please Login or Register to view this content.
Last edited by romperstomper; 10-04-2011 at 03:39 AM.
What's the trick for getting this to work, RS?
See error message and trust center settings in attached screenshot.
The code needs to be in a normal module.
or
In macro, sheet or workbookmodulePlease Login or Register to view this content.
Last edited by snb; 10-04-2011 at 11:14 AM.
Yup!The code needs to be in a normal module.
F5 -- Wowwww!!!
Well, sure... If you use API's...
But seriously, these are great. What fun!
That's very cool rs, I'm going to definitely incorporate that into future projects at work!
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
Seriously! That's all I needed to get rid of the reference?Please Login or Register to view this content.
Internet, you have failed me! If not for the fact that you then provided the solution, I would disown you! Get out! I don't even want to look at you right now!
...
I didn't mean that, Internet. I got carried away. I'm sorry. You know I love you.
Yep.
People seem to get a little carried away with the 'need' for the Extensibility library, I find. It's just early vs. late binding after all.
RS,
I have the 2.0 Object Library and the 5.3 Extensibility checked but when I run the code (in a normal module), I get the attached error. Debugging goes to that same linePlease Login or Register to view this content.
You need to trust access to the VBProject in your macro security settings.
I had to search a little bit but I found it.
All this because I took exception to some code. Must do it more often.
More like, all this because someone decided to announce his 1st anniversary on the forum!
I must do it more often!
Do you think the community would be open to having challenges? Meaning on a regular schedule (say, weekly) a programming challenge would be posted. People could then post their attempts at a solution. It would be up to the community to decide if they want to vote on the responses for a "winner" or if we'd just want to do it for the mental challenge and learning opportunity. Maybe each week the "winner" of the previous week could post a new challenge. Or there could me categories of winners (e.g. "Adheres to Industry Standards", "Fewest lines of code", "Overall", "Most Ingenious", etc.)
Great idea whizz - but instead of a programming challenge, how about I post my here an now REAL LIFE excel challenge and people post their ideas! Like Chandoos site! that way, everyones a winner!! yeyyyyy!!!!
Hey Boys - and Teylyn,,,,, I thought Bob's jibe at snb's sloppy code, snbs subsequent retort, the ensuing battle of the s e x y code which culminated in RS's masterpiece was good enough, but this thread is getting more interesting by the minute, I have just recieved positive feedback (for this thread) from someone (no names mentioned) who hasn't even contributed (to this thread)/ Wowser, can we all now crack on with whizz'z idea of sorting out my dashboard! this weeks programming challenge!!!
Answering OPs questions can be difficult enough at times, never mind challenges from the guru's of this site. Scary proposition
A small revision, give it the personal touch
Please Login or Register to view this content.
Hey Bob -This probably says Happy birthday.. but where in your marvellous code is owner!?
72, 97, 112, 112, 121, 32, 66, 105, 114, 116, 104, 100, 97, 121, 32
In
and thenPlease Login or Register to view this content.
Please Login or Register to view this content.
Thanks mate - now i can send it to my son and change the name - he'd love it.
The code picks up the Windows username, so why not leave it?
Small tweak to add the name one letter at a time:
Please Login or Register to view this content.
Hey RS - this does not run on my 64 bit system!! please, no more sloppyness!
That'll teach you to ignore Microsoft recommendations then.
Seeing the sparks, heck, yes!!
Ok Capt Mannering - Don't panic, i've just opened up the beasts little brother a Precision 390 32 bit and it ran like a dream!
My hero!
I don't have 64bit here to test, but I think this adjusts correctly:
Please Login or Register to view this content.
I deliberately threw up the name all in one, seemed a good touch to me.
You have 64-bit Office? Are you a masochist?
BTW, can we have less sloppiness when spelling sloppiness!
Bob, that was my line!
Seemed a bit abrupt to me, so now we have options.
oh dear - typical, me and my fudge fingers!
why would you say that Bob, what's wrong with 64 bit office? I have found it much quicker.
to answer your question, i'm probably more of a deviant than a masochist!
Last edited by Blake 7; 10-05-2011 at 04:43 AM.
See this article.
Small excerpt:
"The 32-bit version of Office 2010 is the recommended option for most people, because it prevents potential compatibility issues with other 32-bit applications, specifically third-party add-ins that are available only for 32-bit operating systems."
Even MS admit that 64-bit Excel is not the best way to go, yet unless you have a lot of data and using something like PowerPivot, needing to utilise all that memory.
Then I think you should leave immediately, we don't have no truck with them thar types.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks