Can a User Form shape be changed?

Noir

Active Member
Joined
Mar 24, 2002
Messages
362
I use my User Forms for Splash screens but, they all have the same basic square shape. Can you change the User Form to round, oval, etc?

Thx,
Noir
 
Doesn't work for me. Can't seem to get the handler.

FrmWndh = FindWindow("ThunderDFrame", Me.Caption)

Just gives FrmWndh=0
 
Upvote 0

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
On 2002-06-03 05:45, Noir wrote:
Ivan,
OK.How do i get to the point where i select or create the shape of my User Form?

Noir

Hi Noir
It maybe easier if I email you the example, ut basically you just need a loader sub to show the Userform. The form code will takecare of the rest...eg. Clicking on the from will cycle through the different shapes one @ a time. Double clicking on the from will close it down. I left a Doubleclick routine on just in case so that you can dismiss the from this way as the shapes can remove the close button option.

A loader Sub would go something like:

<pre/>
Sub Loader()
Userform1.Show
End Sub
</pre>
 
Upvote 0

Forum statistics

Threads
1,223,243
Messages
6,170,971
Members
452,371
Latest member
Frana

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
Back
Top