Better tool for drawing forms in Excel instead of Excel vba

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,652
Hello All,

What do others on this board use to draw forms in Excel VBA? I am finding it is very hard to precision pinpoint spacing. It just seems that Excel doesn't give you much flexibility with drawing.

Any ides and suggestions will greatly help.

Also what other programs are good for Excel VBA icons on forms? Has anyone found some good freebie stuff out there?

Thanks,


Kurt
 

Some videos you may like

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
L

Legacy 98055

Guest
I have found the opposite to be true about drawing in Excel though the drawing/graphics object model is a bit oblique IMO. What are you referring to when you say "forms". There might be a lot of disparity on what exactly a form is or is a form of what.
 

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,652
Hello Tom,

I am talking about pinpointing moving text boxes around more easily and lining them up better on a UserForm in Excel.

Thanks,

Kurt
 

*shudder*

Active Member
Joined
Aug 20, 2009
Messages
489
Kurt,

Just use the properties settings on the bottom left of the VBA screen.

Select the particular object you want to move and alter the Left / Top settings so that the objects line up. Alternatively you can select multiple objects, right click and then use the 'Align' options.

HTH

Stuart
 
L

Legacy 98055

Guest

ADVERTISEMENT

Hi Kurt. I see what you mean. Are you familiar with the Format functions available by way of the "Format" menu? This might seem like a superfluous question but the reason I am asking it that I frankly did not notice it or use it for some time into my VB stint. Now I find it invaluable and control placement to be quick and easy because of it. If you need help with it, just post as I have not seen much written about it and how to use it.
 

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,652
Hello shudder and Tom,

Thanks and no I didn't use those, so I will try and redraw the form with them.

Many thanks,

Kurt
 
L

Legacy 98055

Guest

ADVERTISEMENT

That's good news! You will find it a HUGE help with control placement. Take a little time to learn how to use it and you'll be glad. I promise...
 

*shudder*

Active Member
Joined
Aug 20, 2009
Messages
489
I wasn't aware of the Format Functions myself, that will save me some time counting the dots when trying to centre buttons.

Thanks Tom.
 
L

Legacy 98055

Guest
Counting the dots!!! :biggrin: I have had those Advil moments. I don't create forms much as it just isn't in my genes to make anything look good, but I have gotten past the dot counting stage. In my experience in programming, I have learned to spend quality time getting to know the tools that are available in the various development GUI's and also the various type libraries. It does indeed save a great deal of time in the long run and headaches as well...
 

Kurt

Well-known Member
Joined
Jul 23, 2002
Messages
1,652
Again many thanks Tom!

I like that Advil counting the dots moment!! lol

Many thanks for your insight!
 

Watch MrExcel Video

Forum statistics

Threads
1,122,657
Messages
5,597,391
Members
414,142
Latest member
Banyangt

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top