Textbox AutoPopulate

**dgingrey** · 09-03-2013, 12:45 PM

Ok so really really really simple question that google can't comprehend.

I need a textbox in a userform to have the value assigned in A1 when a checkbox is activated.

Please Login or Register  to view this content.

I am going to add more lines to the if statement later but what am I doing wrong?

**sperry2565** · 09-03-2013, 12:59 PM

removed, didn't apply. updated below.

**dgingrey** · 09-03-2013, 01:46 PM

I am not sure how that code helps me sperry2526. It is a bit over my head but if I am reading it right it populates the cells not the userform. I have a spreadsheet with pricing data in it. When I open the workbook a userform pops up with a checkboxes. When you select a checkbox the text box beside it needs to display the information in the spreadsheet. For instance if I select checkbox1 then textbox1 should equal the value of A1 if I select checkbox textbox two should equal the value of A2 and so on. I can't get the textbox.value thought to equal the cell. Which is where my problem lies.

**sperry2565** · 09-03-2013, 01:56 PM

Okay assuming the name of your text box is SbTt and your check box is Drv1 then

Please Login or Register  to view this content.

Would another sheet be selected while you do this or would you be looking at the page you're pulling the information from? You could activate the sheet you want to pull the information from when the box is checked...see code. I assumed your sheet was named currency. If not just change the name.

Also my original code populates the text box, not the excel spreadsheet, it just does it on a widescale, as I explained in the post, it's user selected ranges.