Can someone tell how I should define the object correctly in this workbook?
Problem occurs in the following code:
Best, MatthiasPlease Login or Register to view this content.
Can someone tell how I should define the object correctly in this workbook?
Problem occurs in the following code:
Best, MatthiasPlease Login or Register to view this content.
Try
Please Login or Register to view this content.
Last edited by nigelog; 01-22-2019 at 11:17 AM.
.. not working neither..
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
... okey there must be some other problem then.. Still tells me object missing. Gives me the error at :
Please Login or Register to view this content.
So I guess in the second userform is something wrong...
In second userform.
Please Login or Register to view this content.
Okey, now new error at: some problem with column width, which I added now. However then the error occurs at Initialize sequence. The first userform basically runs when I uncomment the second userform. SO there is some problem.. I uploaded againg the updated file.
In what order are the userforms called??
Last edited by nigelog; 01-23-2019 at 06:20 AM. Reason: Update
first UserForm6
and about your answer: "Set rng = [IDS]
---------
but you have no named range [IDS]. Sort that first" --> I dont know how that is done since I have the code from somewhere else. I basically thought this help to set an object...
Last edited by travelkid; 01-23-2019 at 07:52 AM.
@mathias, no problem. I'll take another look after lunch
Is this the direction you were heading with the two Userforms???
See attachment
Last edited by nigelog; 01-23-2019 at 10:10 AM.
Yes that is correct, first number 6 then Gebäudegrundlagen..
See attached worbook - see if this starts you in the right direction
Last edited by nigelog; 01-23-2019 at 12:28 PM.
This is what Im looking for.. I tried to implement your solution into my actual project. There are however errors, I dont know why... So if you have time.. I need to apply this solution to several userforms, so maybe you could describe whats wrong here also..
Thank you very much..
Last edited by travelkid; 01-24-2019 at 04:25 AM.
I have sorted the issues for the two first userforms.
You are going to have to take this in steps. You made changes to the textbox numbering but did not reflect it in the code. You need to remove all non relevant code so it doesn't confuse. And most especially. Fix one thing before you move onto the next, saving a working copy as you go along.
See workbook
Okey thanks again. Now when I press "neu" in the first userform, there are new errors. The idea behind that is, that I can chose wheather I want to edit old entries or creat a new one. Now will I have to create an funciton for the "neu" button also? I would rahter somehow use my old code which would already do the job to make a new entry..
Hi
it doesn't work that way. So far you have your listbox working in userform6 which you can edit because you are finding the data from the ID number. If you are adding a new entry it is totally different code because now you need to check if already exists and THEN copy the entered data to a NEW row at the bottom of the data.
I recognise that code from a member here dotchiejac, which means in his original post you would have received a working copy which includes the "add new entry" code which you can adapt to the new forms.
In your second userform (Gebäudegrundlagen)Initialize change to this.
Please Login or Register to view this content.
Okey, I managed to make the data in the second userform editable. Now heading to the next one... There is a problem however with the initializing code:
The idea is going to be, that in this userform the the data UserForm6.LB_00.Column(i) is shown and i in this bracket will be i + 57 or so... However not sure whats wrong right now since it worked on the last one..Please Login or Register to view this content.
--> I have uploaded the book once more.
The following procedure to find the error message:
--> Start at Userform 6.
--> Chose a entry from list box
--> press "bearbeiten"
--> press "aktualisieren"
--> " ok "
--> Chose "Wärmebedarf" --> error message occurs.
Thank you
Last edited by travelkid; 01-27-2019 at 09:38 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks