Populating userform textboxes with specific record/row in excel worksheet

**danmack** · 10-18-2012, 12:53 PM

Hi all,

Having designed a few basic userforms for input my employers have decided that i'm a VBA genius when in fact i'm self taught from a text book and google (god bless t'internet!).

I have put together a basic userform for inputting information for a new project but am having trouble adding a function that allows users to amend existing records. The line of code that is causing me problems is as follows- Me("TextBox" & j).Text = Format(.List(.ListIndex, j))
The whole section of code that it sits within is as follows ; (shamelessly cribbed and adapted from another source)

Please Login or Register  to view this content.

I'm fairly positive that the issue is something simple/stupid but i'm struggling to work it out. Here's hoping that you can help.

Thanks

Dan

**Norie** · 10-18-2012, 12:58 PM

Dan

I don't know if it's this simple but your textboxes are numbered starting from 1 not 0.

So just replace j with j+1 where you are trying to refer to the textboxes in that code.

Please Login or Register  to view this content.

**arlu1201** · 10-18-2012, 01:25 PM

danmack,

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.

**danmack** · 10-19-2012, 04:10 AM

Thanks Norie, as you'd already guessed it wasn't that simple but your insight has helped me fix the problem and added to my understanding of the code.