How to change size of popup box using macro/vba

[5haks]

Hi,

I have a problem where a pop up box that contains staff names is not long enough and although it has a scroll bar, it cuts off the last 15-16 names on the list. Is there any way I can change the size? I've tried looking for the "FORM" on vba in excel but for some reason I can't find it in the list of modules, forms and objects etc. There is a macro assigned to a button which allows for the pop up box to show up but I really don't know why I can't find it anywhere in the background.

Is there any way the person designing this has hidden the "FORM"? If so, how do I unhide it


Please help me urgently as i need to get this done by today!

many thanks

[AliGW]

We cannot guarantee that this will be solved today.

Please remember that those who help here do so voluntarily and of their own goodwill. They live in many different time zones and many will be out at work right now if they are not asleep on the other side of the globe. This is not a paid 'service': members will help when they are ready and able to do so, and not 'on demand'. Please do not try to put pressure of time on anyone here: if you get the help you need today, that's fine, but you really should not count on it. Thanks for your understanding and patience.

[5haks]

ok, brilliant. Thanks!

[xlnitwit]

Are there any dialog sheets in the workbook?

[5haks]

stupid question, what do you mean by dialog sheets?

I can only see objects, forms, modules and class modules

[xlnitwit]

Dialog sheets are like a kind of worksheet. Are there any hidden sheets in the workbook?

[AliGW]

Will you please attach a sample Excel workbook?

1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired results are also shown (mock up the results manually).

3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

4. Try to avoid using merged cells as they cause lots of problems.

Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

[5haks]

yes, all the sheets are hidden except 3 but none of them relate to the staff list which I am trying to resize

[xlnitwit]

Are they all regular worksheets?

[5haks]

yes normal worksheets with no extra coding

[5haks]

removed attached file.

this post can be closed as solved as I have managed to get the desired results.

thanks