I have written an ODBC report that I have parameter which I want users to
suuply via a VBA form.

How do I get the value from the form text box to a specific cell on a
specific sheet? I know I need some code behind a command button to do this
but a starting point would be greatly appreciated - cheers

Tia

Hi Jonathan,


The code goes behind the click event of the button. Below assumes you've
also got a text box name "txtBox1" on the form:

Private Sub CommandButton1_Click()
Application.ActiveWorkbook.Worksheets("YourSheetNa me").Range("A2").Value
= Me.txtBox1.Value
End Sub

Best regards

John

"Jonathan" wrote in message
...
I have written an ODBC report that I have parameter which I want users to
suuply via a VBA form.

How do I get the value from the form text box to a specific cell on a
specific sheet? I know I need some code behind a command button to do
this
but a starting point would be greatly appreciated - cheers

Tia