Hi all,
I'm trying to make an excel sheet that will fill in labels to a 96 well plate in order to sort and calculate the data.
The problem is when i set up the textbox in the user form i want it to pull data on the plate format from cells that have already been filled in using another userform i have created for the standard curve.
My userform has 96 text boxes (one for each well in the plate). They have been named A1 through H12 corresponding to the wells. What I have written is:
Private Sub PlateFormat_Intialize()
A1.Value = Range("Q2").Value
End Sub
with Q2 being the cell in the workbook that it should pull the text from
The userform always loads with the textbox blank.
What am i doing wrong? I tried activating the correct sheet in the workbook first that doesn't help. I included a command button where i put the same value code in and then it will update. I don't want to have to update the form however. I want it to load with the cells filled in.
Thanks!
I'm trying to make an excel sheet that will fill in labels to a 96 well plate in order to sort and calculate the data.
The problem is when i set up the textbox in the user form i want it to pull data on the plate format from cells that have already been filled in using another userform i have created for the standard curve.
My userform has 96 text boxes (one for each well in the plate). They have been named A1 through H12 corresponding to the wells. What I have written is:
Private Sub PlateFormat_Intialize()
A1.Value = Range("Q2").Value
End Sub
with Q2 being the cell in the workbook that it should pull the text from
The userform always loads with the textbox blank.
What am i doing wrong? I tried activating the correct sheet in the workbook first that doesn't help. I included a command button where i put the same value code in and then it will update. I don't want to have to update the form however. I want it to load with the cells filled in.
Thanks!