PDA

View Full Version : Formatting tables made with user form



Mugsie
12-20-2011, 09:35 PM
Hello, I'm a newbie to VBA.

I'm trying to create tables using a form. I have been able thus far to gather input and create a table using my form, but need help with the formatting aspects of tables.

Here's what I've been able to do so far:
1. User enters rows and columns
2. User chooses a caption style
3. User enters text for table's title

All of the above works like I want it to.

Here's where I'm having a problem:
4. Table needs to have a different font size than the rest of the body text
5. I know you can select a range of cells, but every table will be a different size and there will be multiple tables so I'm not sure how to handle that.
6. Every table will need to have a footnote for source information.

Any help is greatly appreciated. I'm really stuck on this one.