LinkBack URL
About LinkBacks
Hello,
why isnt it possible to open the next userform here? --> error message : object rejuired ( -424)
Please Login or Register to view this content.
Hello,
why isnt it possible to open the next userform here? --> error message : object rejuired ( -424)
Please Login or Register to view this content.
Last edited by travelkid; 01-16-2019 at 10:00 AM.
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Click on Edit to open your thread, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 6)
Travelkid, could you provide a sample workbook to investigate please?
The error could be a typo in the form name, but it could also have to do with the userform_initialize event in the next form...
To attach a book:
Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
Where do you get the error?
What do you mean the 'next' userform?
If posting code please use code tags, see here.
Okey. Arkadi was right. It was a typing error but also there is an issue with Initializing. --> It corrected the typing issue and uncommented 2 lines in the initialize area to make things work. Howver now the values from the datasheet are not shown anymore in the LB_00 box, what should acually be the case.
Also I have another question. As one can see, it is possible to pick a line from the LB_00 box and edit those. What Im looking for is that, when I pick a line a can edit the values in the first userform and then continue to the second userform and directly edit the values there also, without having to pick out again the line...
The example is attached.
Best
When I open either form manually LB_00 is populated.
How are you opening the forms?
LB_00 are not userforms but list boxes...
In the first sheet press on the button and the forms will open or what doy you mean?
When I un-comment those 2 lines, LB_00 is populated without error?
Also, if both forms load from the sheet... then maybe when you edit a line and press edit (Bearbeiten) it should save to the sheet before the second form is loaded?
Last edited by Arkadi; 01-16-2019 at 12:23 PM.
Well, if ['.ColumnWidths = "40;150;150;70;50;150;70;70;70;70;120;70;70;70;70;70;70;70;70;70;70;70;70;70;70;70,70"] is uncommented then it works.. not quiet sure yet the columnwidths stans for.. I negelct, not the most important issue right now.
Yes saving before the next userform opens is a godd thing. I guess at the end it should be possible to navigate back and forth to make changes. Also it may become an option that the list box is not shown any more on userform 2 but just the values..
Best and thanks. I would really appreciate if that one was solved.
Eh, I know they are listboxes.Originally Posted by travelkid
When I open the userforms manually those listboxes are populated, as the first one does when I open it using the button on the first sheet.
... Sorry I dont get your point?
When I open the userforms the listboxes are being populated and I get no errors.
In your original post you said you were getting an 'object required' error, then in subsequent posts you mentioned the listboxes not being populated.
So I'm a little unsure what the problem is, did I miss something in an earlier post?
Ah okey, yes this one was solved. I added another question:
"Also I have another question. As one can see, it is possible to pick a line from the LB_00 box and edit those. What Im looking for is that, when I pick a line a can edit the values in the first userform and then continue to the second userform and directly edit the values there also, without having to pick out again the line..."
Best, Matthias
I guess part of the problem is our lack of understanding exactly what you want. Since the 2 forms load exactly the same data, I am confused by the overall book.
Why do all the buttons set LB_00's listindex to -1? If you leave an item selected in form1 then you could in the userform activate for form 2 set the listindex of LB_00 in form2 to the same as LB_00 on form1?
I know the workbook does not make a lot of sense. This is not the endversion.. Anyway your idea with leaving an item selected sounds good to me.. How would I have to do this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks