Userform value to active cell

[ipbr21054]

Hi,
On Searching for a code I can only see how to get a value from active cell to a userform textbox.

I’m wanting to have a value from textbox1 put in the worksheet active cell.

Can you advise please.

 

[dreid1011]

Something along the lines of this maybe:

Activecell.Value = Textbox1.Value

 

[ipbr21054]

How would that work from a userform.
Open userform & enter the value so when closing userform the value is now in a active cell.

Seems to be to easy seeing that I was unable to find anything when searching.

 

[dreid1011]

How would that work from a userform.
Open userform & enter the value so when closing userform the value is now in a active cell.

Seems to be to easy seeing that I was unable to find anything when searching.

Can you show the userform code you are using? Use the vba code tags to post it.

 

[ipbr21054]

I haven’t started it yet. 5am woke up thinking of how to do it ha ha

My goal is to get value from textbox to active cell.
Or input box value to active cell.

Also need advise if possible to do this.
Open userform where a textbox would show active cell address.
So if a five cell is Z22 then when I open my userform say textbox3 would populate with Z22

Thansk.

 

[ipbr21054]

This is the simple idea i have but get a run time error 438 OBJECT DOESNT SUPPORT THIS PROPERTY OR METHOD
Been strugling for two days to get a move on.

The cell is selected & my userform opens.
I enter a number is Textbox 1 say 500
I press the command button expecting the value of 500 to now be shown in the active cell.
But this is when i get the error message

Private Sub CommandButton1_Click()
   
    With ThisWorkbook.Worksheets("DATABASE")

    ThisWorkbook.Worksheets("DATABASE").ActiveCell.Value = Me.TextBox1.Text 'MILEAGE FROM LAST MONTHS SHEET
    
    Unload UserForm1
End With
End Sub

 

[Artik]

Private Sub CommandButton1_Click()
   
    ActiveCell.Value = CLng(Me.TextBox1.Text) 'MILEAGE FROM LAST MONTHS SHEET
    
    Unload Me
End Sub

Artik

 

[ipbr21054]

Sorted now many thanks