Home |
Search |
Today's Posts |
#1
|
|||
|
|||
From Excel to user form
Hi,
how can I make this code for user form and text box instead of sheet and cells Private Sub Worksheet_Change(ByVal Target As Range) 'Only single cell selections are of interest If Target.Count 1 Then Exit Sub Application.EnableEvents = False 'Is the cell that changed the one we want? If Target.Address = "$C$14" Then Range("$E$21") = Target * Worksheets("Sheet2").Range("$G$5) End If Application.EnableEvents = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel user form | Excel Programming | |||
Is this possible in Excel (User Form) | Excel Programming | |||
Excel User Form | Excel Worksheet Functions | |||
Date field in user form & Loading a user form on opening workbook | Excel Programming | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming |