Run Time error 91 while updating texts in textbox in userform

**Cijo** · 08-22-2012, 03:05 PM

I have a userform with textboxes and listbox.

All new values from my textbox I am able to add from textbox to an excel sheet.

When it is coming for editing I am unable to update and save the edited data from textbox to that particular cell value.

Following is my code for saving edited datas from textbox to particular sheet cell

Please Login or Register  to view this content.

------------------------------------------------------------------

While editing from "Ascot" to "Asco" I have no problem.
But when I type any new alphabet in the textbox like from "Ascot" to "Ascot Royal" I get the Run time error 91 message.

plz help. Thanks

**Cutter** · 08-22-2012, 03:30 PM

@ Cijo

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**wallyeye** · 08-22-2012, 06:39 PM

You don't check if there is a valid match, I suspect that is the case:

Please Login or Register  to view this content.

I suspect the employee.rows.offset(0,0).value = b.value isn't right either, where are you trying to place the name relative to the found name, and what do you really want to put in the cell?

**Cijo** · 08-23-2012, 05:01 AM

[QUOTE=cijo] Imagine I have to add one value say "Ascot" to a sheet cell from textbox using 'ADD" button. Later I want to change the value from Ascot to Ascot Royal to that same cell from same textbox using 'Save' button. This is my goal using 'save' button.

Regarding string variable "Name"; when i click one value of listbox, 'b' textbox gets updated with the corresponding value from the cell. That value is stored in the variable 'Name'. That 'b' text value when i want to edit, I get this problem.

**wallyeye** · 08-23-2012, 07:48 PM

The problem is Name and b have the same value. What you need to do is store the value of b in a separate control, say c, that is populated at the same time as b. Then, in the Click event, just replace Name with c.value:

Please Login or Register  to view this content.

**Cijo** · 08-25-2012, 04:05 AM

[QUOTE=cijo] Thanks Pal, its working, though not in the code you have given me, but your idea of storing the value of b in a separate control helped me in my problem.

Thanks.

**Cutter** · 08-25-2012, 09:08 AM

@ Cijo

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.