Code to Initatiate Userform workeb but now I get Run Time 381

[jaredmccullough]

The strangest thing has happened. I have simple Userform.Show codes in a module which I have assigned to shapes on a spreadsheet. Some of them still work but others throw a Run Time 381 Error Code?

Any suggestions.

[jaredmccullough]

bump for help

[Vikas_Gautam]

Need to have a look..
So

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[jaredmccullough]

DRAFT PLT-50-B Contractor Variance Database.xlsm

See above attached file.

Essentially when you enter be sure you are on worksheet "Home" and click on the dashboard text that says "Print Variance" (i.e. this is actually an object with an assigned macro) The macro itself is just to stimulate a userform but at this point is currently not working....???? at a loss as to why.

[jaredmccullough]

Need to have a look..
So

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Added attachment sorry I forgot to quote before.

[john55]

see UserForm CVF14

Please Login or Register  to view this content.

[jaredmccullough]

see UserForm CVF14

Please Login or Register  to view this content.

John,

I guess I am somewhat confused....so you are saying that the previous activate code for userform CVF14 was not allowing it to initiate?

Also try the "Edit Variance" or "Approve Variance" at the top of the dashboard as they are encountering the same problem.

[Norie]

There's only one value in column A on the sheet 'Variance Database'.

To populate a listbox with a single value you need to use AddItem instead of List.

So try this code for the form's Initialize event.

Please Login or Register  to view this content.

PS Don't seem to have a problem with Edit Variance but you can use the above code for Approve Variance.

[jaredmccullough]

There's only one value in column A on the sheet 'Variance Database'.

To populate a listbox with a single value you need to use AddItem instead of List.

So try this code for the form's Initialize event.

Please Login or Register  to view this content.

PS Don't seem to have a problem with Edit Variance but you can use the above code for Approve Variance.

Norie,

Thank you as I was unaware of this requirement so just to clarify if (1) item it needs to be AddItem instead of List?

What is the cause for this requirement?

Jared

[Norie]

Jared

I believe it's because a range consisting of more than one value will return an array whereas a range of only one value will only return the value.

[john55]

Hi
Norie is right!
I saw that you have one item in column A, so initially I tested it with more items (such as "aaa", "bbbb", etc) and it worked.
I wish you success!