Hi All
I have 2 comboboxes. I want to align them one next to the other in midle of a sheet.
I have already created 2 buttons to show them.
How can I do it with gap and without gap?
Attached is the file.
Regards
Hi All
I have 2 comboboxes. I want to align them one next to the other in midle of a sheet.
I have already created 2 buttons to show them.
How can I do it with gap and without gap?
Attached is the file.
Regards
Hi Paul001 and welcome to the forum.
I modified your file and it is attached.
One easy way to achieve what you are asking is to modify the properties of each UserForm. This is what I did to yield the result in my file.
While in the VB Editor, select the UserForm. Then in the properties window (lower left) set StartUpPosition to Manual. Then change the values for Left and Top to place it on the worksheet where you prefer.
There are more involved ways of doing this but I find this the simplest. The down side is that if you change the size of the UserForm you will need to adjust the value for Left for one or both UserForms.
Hope this helps; if so please mark my answer as selected answer.
Cheers ;-)