UserForm's Width

[rdrmdr]

Is there any way, without faking it, to actually do this:

Please Login or Register  to view this content.

Problem: UserForm's Width's Minimum Value.

My project: I have a borderless UserForm and I need the width of it to be set to 75,75.
(I don't wanna make it half transparent or any of that)

Thanks in advance!

[6StringJazzer]

This seems to be a hard limit. Why do you want such a narrow width? Maybe we can come up with another way to solve your overall problem.

[rdrmdr]

I'm trying to resize the width because of this black space:

L4keJKY.png

[cytop]

There is a minimum width - somewhere about 102 whateveritis's used to define the width. You cannot get around that even if you set the border sizable.

[rdrmdr]

I already know about that. What I'm asking is if there's any possible way to somehow change the width even with that minimum value, I don't know, APIs seems to solve everything if you know what to call...

[rdrmdr]

I guess I will just make it 2x bigger but I really don't like the limitations... I know it's Excel 2007 but it's what I have to use here.
At home is the most recent Visual Studio

[rorya]

You can't do it, but you can fake it: http://stackoverflow.com/questions/2...ess-than-29-25

[cytop]

You can do a lot with APIs - make the border sizable, remove the caption, make a small 'tooltip' caption bar, prevent the userform from being moved on screen, set the min and max allowable sizes (without that annoying flicker you get if the size is set in the Resize event) - but you cannot make it any narrower than 102 if the title bar is visible, but you can get that down to 12 (Ahem - See post #11) without a title bar ...

I realise that contradicts what I said earlier - just keeping it simple.

[rdrmdr]

you can get that down to 12 without a title bar ...

How? Isn't removing the borders, removing automaticaly the title bar?

[rdrmdr]

Well, I do have a module that makes the form transparent and the controls visible but it takes some time to load (depending of the form's size) ...

[cytop]

No. Removing the title bar is yet another API call.

Short video showing a userform with the various attributes selectable. Making it Resizable and removing the Caption (Title) bar allows the form to be made very small, min 6 height & width, but that's a bugger to make bigger!): https://tinytke99-mailinator.tinytak...jAyXzMxNTEyMTE

New versions of Excel have played around with the GDI (Graphics Device Interface). That sample shows a very thin caption bar. This was not evident on Excel 2007 systems (Video of userform in XL2007 running in a Virtual machine: https://tinytke99-mailinator.tinytak...zM3XzMxNTE1MzE)

I'm working on getting rid of that on newer versions...

[rdrmdr]

I'm working on getting rid of that on newer versions...

You look like a developer .
Are you ?

[cytop]

Sometimes. I develop turnkey systems in Excel - the speciality is making it NOT look like Excel

[rdrmdr]

Can I ask a thing. Don't get me wrong but why does so much people still uses this?
I can't find anything better than visual basic/visual studio rather then:
It has excel/workbook (the cells and all of that) and it may be faster (IDK).
I only use on work. I think the overall of the VBA is weaker than VB.
Don't hate me...

[cytop]

I think the overall of the VBA is weaker than VB

True. VBA is a subset of Classic Visual Basic 6 (Although I think it was actually VB5 that was the source). Just about any other language is faster, even classic visual Basic.

It is widely used because it is simple to pick up and is tightly integrated with Excel/Word and other Office applications. Users with a little bit of common sense and a knack for Google can end up writing complex systems which, over time, become the king pin for the office, if not the entire division, or even company. Fred, who wrote the system, then falls under a bus or gets a job with a competitor (or simply retires to a desert island 'cos his system enabled him to embezzle his Drop-dead money) and suddenly the whole place is in a panic - lots of that type of work around .

The other common work pick-up is a place that decides to try and do it themselves, get's 70% of the way through it but then find they don't have the skills necessary to complete. The choice then is live with what they have (usually not an option), throw it away and write off the investment, or get someone in to finish it off.

It's a lot more daunting to develop Excel add-ins or templates using Visual Studio, which is the next easiest way to integrate things with Office Apps, but the learning curve is a lot steeper and a lot longer - and that equals more expense (in the short term, at least).

Don't hate you, I used Classic Visual Basic right from version 1 to Version 6 & NET - I can't stand NET so 'dropped down' to VBA to stay with something as close to VB6 as still eixsts.

[rdrmdr]

I once saw a dinassaur meme saying something like:

If you need a program to program a program, than how do you program a program to program a program?

I love that.
It means something like, if you need VB to code your program, than how do you code a program to code VB (...to code your program)?
And now that can be looped.
If you need a program to program a program to program a program, than how do you program a program to program a program to program a program?
That means, if you need VB to code VBA to code your program, than how do you code a program to code VB (...to code VBA to code your program)?

The worst is that with that philosofy you get nowhere because the programs are not public or there's really low information about them...
The companies just create them for them selfs and then program stuff for us, the clients. It's hard to learn about 'programming directly on the BIOS?' or using some language like C but what compiler you ask, well, the compiler is written in C to, wtf?
The End