Hi All,
I have recieved som invaluable help from this forum recently so thanks to everyone wha has taken the time to reply.
Although I am slowly getting to gips with the basics I have yet again come up against an issue which has me slightly stumped.
I am using a worksheet as a data entry tool (rather than a userform as it will be used by numerous ops and I have experienced issues regarding display sizes in the past)
The data entry worksheet contains Textboxes into which the Op enters the required information.
This (by means of a command button) is then copied to a data sheet.
I then Have 3rd(summary) sheet which is extremeley similar to the data entry sheet but is used to display the information, the op selects a given number from a Combobox which is tied to a named range and the textboxes display the data based on that selection.
I have this all working perfectly.
My question is if I wanted to allow the user to change the value in a specific textbox on the summary sheet, how would i then then ensure that the updated changes are saved to the correct cell on the worksheet when a command button is pressed.?
I have manged do this in the past when using userforms by using the following code:
Private Sub CommandButton1_Click()
Range("MyRange").Cells(ComboBox1.ListIndex + 1, 2) = TextBox1.Value
End Sub
But When I try and utilise this code for a worksheet based textbox i get a Run time error 424 Object required.
I presumed I am defining the object above but obviousley not.
Can anyone help?
Thanks in advance
I have recieved som invaluable help from this forum recently so thanks to everyone wha has taken the time to reply.
Although I am slowly getting to gips with the basics I have yet again come up against an issue which has me slightly stumped.
I am using a worksheet as a data entry tool (rather than a userform as it will be used by numerous ops and I have experienced issues regarding display sizes in the past)
The data entry worksheet contains Textboxes into which the Op enters the required information.
This (by means of a command button) is then copied to a data sheet.
I then Have 3rd(summary) sheet which is extremeley similar to the data entry sheet but is used to display the information, the op selects a given number from a Combobox which is tied to a named range and the textboxes display the data based on that selection.
I have this all working perfectly.
My question is if I wanted to allow the user to change the value in a specific textbox on the summary sheet, how would i then then ensure that the updated changes are saved to the correct cell on the worksheet when a command button is pressed.?
I have manged do this in the past when using userforms by using the following code:
Private Sub CommandButton1_Click()
Range("MyRange").Cells(ComboBox1.ListIndex + 1, 2) = TextBox1.Value
End Sub
But When I try and utilise this code for a worksheet based textbox i get a Run time error 424 Object required.
I presumed I am defining the object above but obviousley not.
Can anyone help?
Thanks in advance