listbox`s always change size when i close and re-open up workbook

[jeff]

Hi All

Is there anyway possible to have the 10 listbox`s to remain at a static Height - 250 and Width - 150 in size....everytime i open up the workbook the listbox`s get smaller and smaller each time.

Is there any possibility of Listbox`s always being Height - 250 and Width - 150 in size and that they do not move at all in the spreadsheet.The positioning of each Listbox goes underneath each column
Regards

Jeff

[snb]

Set the property 'integralheight' to False.

[jeff]

Thanks snb

That fix the issues.

Is there any possibility with the protected sheet of also allowing the Listbox`s to be enabled as currently with the protected sheet I cannot select the Listbox`s to change unless I un-protect

Regards

Jeff

[snb]

A userform would be advisable.

[jeff]

I have not created userform before but prepare to learn .. how would a userform replace the Listbox`s

Jeff

[jeff]

Hi

Still curious as to how you would implement a userform instead of the Listbox`s....

Jeff

[snb]

Have a look over here:

Create an Excel UserForm