Return value from sheet to textboxes based on value on another textbox

**impresxy** · 10-04-2017, 08:23 AM

Hi,

I have problem to populate value on textboxes in userform based on value in the combobox I have selected. Here is my code, I found it useful but i got yellow error line on 'LastRow' and there is nothing populated on textboxes. My column A is actually customer ID which contains purely number e.g. 10000001.

Can anyone please help me ?

Please Login or Register  to view this content.

**kev_** · 10-04-2017, 08:43 AM

replace:

Please Login or Register  to view this content.

with:

Please Login or Register  to view this content.

Your problem is caused by the "incorrect" quote marks
“ ” is not the same as " "

**impresxy** · 10-04-2017, 08:49 AM

Ohhhhh,

Thank you so much ! I was working the whole day and get blur in my eyes.

**kev_** · 10-04-2017, 08:55 AM

you are welcome
thanks for reps

Please mark thread SOLVED
(see thread tools at top of thread)

Return value from sheet to textboxes based on value on another textbox

LinkBack

Thread Tools

Rate This Thread

Display

Return value from sheet to textboxes based on value on another textbox

Re: Return value from sheet to textboxes based on value on another textbox

Re: Return value from sheet to textboxes based on value on another textbox

Re: Return value from sheet to textboxes based on value on another textbox

Thread Information

Users Browsing this Thread

Similar Threads

Re: If value match of textboxes then overwrite the value of column(N)

[SOLVED] enable number of textboxes based on input in another textbox

[SOLVED] Sum three textboxes %age in one textbox on userform

How to concatenate two or more textboxes in one textbox

[SOLVED] Several Textboxes values into one textbox

Return value of TextBox into cell of new sheet

How to update textbox from other textboxes

Bookmarks

Bookmarks

Posting Permissions