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

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

Set the property 'integralheight' to False.

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

A userform would be advisable.

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

Jeff

Hi

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

Jeff

Have a look over here:

Create an Excel UserForm