Table Maker Input

[vamosj]

Long ago I created a Table Maker for use in the merchant forum and I was wondering how many of you have used it and if you have, are there any items that you'd like to see get implemented. I have a little bit of free time on my hands so I was looking to make version 2.0 of the table maker.

For those who haven't used it you can find the download link in my signature...

[Whirlin]

I wouldn't use an activecell offset, but rather determine the array and use a for each in range statement

Also, I believe the subroutine for finding the color could be simplified greatly... there has to be a way to return the cell color rather than all the ifs

May want to execute the color Form on startup routine.

May want to post optimization questions on excelforum.com, where I happen to also frequent... Although, may want to take off that pesky VBA password... delays us by a couple seconds before we can get into your code :p. And CAC Card is not actually the VBA password!

[vamosj]

Okay, I get it, you're better at VBA than I am...

Now back on topic, other than coding issues as I'm well aware that I'm still pretty novice this but just trying to give back to the community, I am looking for things that I could possibly add to the current table maker that would help those who sell stuff on the market..

[Whirlin]

Just trying to help out!

I found that coding VBA becomes a crazy tiered process. You begin by basically copy/pasting whatever the Excel record macro creates you, and maybe make a few little adjustments here and there to make it work a little better.

After that you become a little better with variables and some loop statements, the overall length of the code is probably cut in half.

Beyond that, you become ridiculous at variable declarations and subroutine management. At this point, everything is starting to get ridiculously complicated.

One step further, and that's when someone rewrites your entire macro in a single VBA line... You study it for a while and just throw your hands up and just say WTF.

I love working with VBA, it's very akin to learning excel... Start off with one convoluted method of solving a problem, but then it becomes more and more concise and polished, like jumping from matches, to vlookups, to sumproducts!

Unfortunately, as I'm sure you've seen, even with the table maker, people don't tend to use tables too much in their sales, and I don't think that's an issue with your spreadsheet or code, but more about the ease of updates, and just doing it all within the website. Additionally, the length of things like scripts can really mess with table formatting, which isn't an issue from your macro, but more from the PHP autoformatting of tables.

But I definitely think the table maker should be stickied, or something to that extent to make it easier for people. It's a good tool, and does make sales look a little more polished.

[vamosj]

Thank you... yes, I've seen the process of VBA education, or at least self VBA education and I've thrown my hands in the air a few times saying Why the fuck was that so simple and it took me how long to figure it out?

Anyway, yeah I think a lot of the posts placed here would look better within a table but the problem is coding the table, which was why I created this spreadsheet, to do just that. I did the same thing at work for our sharepoint.. I have a scrolling marquee to show announcements to our staff and since it is HTML driven, I created a spreadsheet that all they have to do is update the announements, click generate, then it saves a text file that holds the HTML code that all they have to do is upload to the sharepoint site and it's done...

I'm always looking for new ways to use and implement excel stuff so it kind of forces me to learn more about vba and it's functionality.