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 |
All times are GMT +1. The time now is 01:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com