Very Simple Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

cjwenngatz@gmail.com - 19 May 2006 00:43 GMT

I'm creating my very first VBA form (Im a Newb), but I'm wondering how
to get the number that is typed in a a "textbox" to immediatly alter to
a negative amount when it is submitted and populates into the sheet?

Thank you,
C.

Reply to this Message

Tom Ogilvy - 19 May 2006 02:51 GMT

Use the event to write it to the cell

Private Sub TextBox1_Change()
if isnumeric(Textbox1.Text) then
Worksheets("Sheet1").Range("A1").Value = _
-1 * Abs(TextBox1.Text)
end if
End Sub

Signature

Regards,
Tom Ogilvy

> I'm creating my very first VBA form (Im a Newb), but I'm wondering how
> to get the number that is typed in a a "textbox" to immediatly alter to
> a negative amount when it is submitted and populates into the sheet?
>
> Thank you,
> C.

Reply to this Message