VBA - Textbox Link With Cell

[prawln]

Hey guys,

I'm trying to make a macro that has a Textbox and a button so when I add a value in the textbox it will change value in a cell.

This probably makes sence but ill explain what im doing.

In Cell F10 is a USA$ number and G10 is for NZ$. What I want to do is to be able to enter the current USA$ to NZ$ exchange in the textbox then hit a button and it will update the cell with the current dollar exchange.

The formula to do this in a cell is (this to be put in G10) =F10/0.460 (0.460 is the current exchange rate) So if F10 says $15 with the formula =F10/0.460 it would equal $32.608 NZ$.

So yeah what I want to do is enter the new exchange rate (0.460) into the text box and have it change it in cell G10.

I might be asking to much but thought I would throw it out there.

 

[VoG]

With a textbox on a userform try like this

Private Sub CommandButton1_Click()
Range("G10").Value = Val(TextBox1.Text)
Unload Me
End Sub