LinkBack URL
About LinkBacks
I'm trying to do an arraylist of fonts but I keep getting the error Object variable or with block variable not set. here is my code:
Can you create Font arrays?
Please Login or Register to view this content.
I'm trying to do an arraylist of fonts but I keep getting the error Object variable or with block variable not set. here is my code:
Can you create Font arrays?Please Login or Register to view this content.
Last edited by andrew c.; 08-04-2011 at 01:52 PM.
Hello Andrew,
What type of an array are you trying to create? A array of font names or something else?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I would like an array that gets the font formatting, so if it were in bold or italics, or both, etc. But I don't want to make a ton of boolean arrays for bold, italics etc
Hello Andrew,
You can get those settings using the Font.FontStyle property which is a variant.
Please Login or Register to view this content.
ohhhh Thanks a Ton!!!
This doesn't take into account the font size. Will I need a seperate array for this?
Last edited by andrew c.; 07-27-2011 at 05:12 PM.
Hello Andrew,
Glad I could help.
Leith Sorry I went back and edited my last post so you probably didn't see my question, but is there a data type other than fontstyle that will take into account the bold, italic, as well as the font size. Currently the size is not being adjusted from font style?
Hi Andrew,
One thing you could do is create a structure called a user defined type (UDT) to hold the relevant values you need. For example:
It's quite unusual to give an array a lower bound of 7 though. Usually programmers use 0 or 1.Please Login or Register to view this content.
By the way, the reason the code errored in your original post is because Font is an object, so you need to use the Set keyword:
Please Login or Register to view this content.
Thanks Colin
I started the array at 7 because it references static cells, so it make more intuitive sense this way.
Where do you put the type declaration? I did it outside the sub and I got the error on declaring the array of tFont that the user defined type didn't exist.
Hello Andrew,
You need to place the type declaration at the top of a standard VBA module before any Sub or Function definitions.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks