Formatting Text Box On Userform

[Jingles3X]

Good Morning!

I am curious if anyone would be willing to share pictures of a 'Main Menu' they have made for a VBA project.
I am creating a proposal generating tool to keep things consistent with my small business, and want to have
a main menu that will list each task in the proposal process, with a button to enter text, calculate costs, etc...
but everything I try looks like garbage.

I thought maybe seeing what some others have done might help me see some good ideas in my noggin.

 

[m_in_spain]

Hi,
Over the last 3 or so years I have been developing a quoting system. I was fed up with generating quote time and time again, all the the same but different, all had cut and pasted errors carried over the versions! so i set about a huge project which covers the range of 10 main lines, totally there are over 1000 options available once the main unit has been specified. My program creates the excel cost sheet, fills in a word doc, using bookmarks from a template document, deletes unwanted parts of the master quote, pfinds and inserts specific pictures to the quote and finds appropriate drawings, makes a pdf of the word doc, add the pfd drawings and files them all in a unique folder. My "Main Menu" is attached: ( have removed the company badge!) Green Areas are auto filled, Blue are for typing in and pruple are drop down selections, the other buttons go off to different areas as this work book has grown and grown and grown. Any areas of the VB where i have become stuck, I have always got the answers from this forum!

Hope it helps!

 

[Jingles3X]

Hi,
Over the last 3 or so years I have been developing a quoting system. I was fed up with generating quote time and time again, all the the same but different, all had cut and pasted errors carried over the versions! so i set about a huge project which covers the range of 10 main lines, totally there are over 1000 options available once the main unit has been specified. My program creates the excel cost sheet, fills in a word doc, using bookmarks from a template document, deletes unwanted parts of the master quote, pfinds and inserts specific pictures to the quote and finds appropriate drawings, makes a pdf of the word doc, add the pfd drawings and files them all in a unique folder. My "Main Menu" is attached: ( have removed the company badge!) Green Areas are auto filled, Blue are for typing in and pruple are drop down selections, the other buttons go off to different areas as this work book has grown and grown and grown. Any areas of the VB where i have become stuck, I have always got the answers from this forum!
View attachment 50694
Hope it helps!

Thank you! I am in a similar situation, with a twist.... while there are no major errors or issues, The output from the quoting system the company uses looks like rotten ***, and should not be something we use to put in front of a customer while we are asking them to make major 5 and 6 figure purchase. I have all the accurate data in front of me, it just looks awful so I am putting together a quoting tool that will have all of the same info that can chosen from dropdown boxes, list boxes, check boxes, a few text entry boxes for scope of work, etc... then export the whole thing to pdf....if I could get the checkboxes to transfer, or list boxes to populate (new to vba). Thanks for sharing.