Populate Userform with spreadsheet data, then Edit it

KenCriss

Active Member
Joined
Jun 6, 2005
Messages
326
I am sure there is a way around this but I have not figured it out.

I am populating a Userform with data from one of the sheets in the workbook. I want the user to be able to edit the textboxes on the form with updates to the data, then with a click of a button I am posting that updated data to another sheet. I could have sworn I have done this before but when I try to type in one of these populated textboxes, it will not let me type.

Here is an example of how I am populating the textbox. Pretty simple.
TB_FName.Text = ActiveCell.Offset(0, 1).Text

So why can't I change the data in the text box? Thanks!
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
What other code, if any, do you have in the userform?

Also, are any of the controls on the formed linked to cells on the sheet the data is coming from?
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top