Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
How can I copy the command button and macro for multiple rows ?
Private Sub CommandButton1_Click() Dim Outlook As Object Dim Appointment As Object Dim Category As String Dim Time As Variant Const Item = 1 Set Outlook = CreateObject("Outlook.Application") Set Appointment = Outlook.CreateItem(1) Time = "08:30AM" Appointment.Location = Range("a2") & ", " & Range("d2") & ", " & Range("e2") Appointment.Subject = Range("i2") Appointment.Start = DateAdd("d", 350, Range("b2")) & " " & Time Appointment.Body = Range("a2") & ", " & Range("b2") & ", " & Range("c2") & ", " & Range("d2") & ", " & Range("e2") Appointment.ReminderPlaySound = True Appointment.Display 'Outlook.quit 'Set Outlook = Nothing End Sub -- problem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run a macro using a command button | Excel Discussion (Misc queries) | |||
Command Button to run a Macro | Excel Worksheet Functions | |||
Run Macro from Command Button | Excel Discussion (Misc queries) | |||
macro to copy multiple rows to separate worksheets | Excel Worksheet Functions | |||
Using Command Button to copy cells | Excel Discussion (Misc queries) |