N
newbie
Hi,
I have two questions about Excel VBA and hope any experts can give me a hint
(1) I wonder how to retrieve automatically the previously saved values from
the combo box and a group of radio buttons whenever I open the workbook?
(2) Everytime I need to insert an object, I copy the object to one worksheet
(named as SLD) from another worksheet (named as Lib) which acts like a
library. However, because of using the function "SELECT", I encounter
"flickering" on the main sheet (named as Sheet1) each time an object is
inserted. Is there any way that I could eliminate this flickering? Your
advices are greatly appreciated.
Public Sub OffshoreTrfr(ByVal myValue As Integer, myType As Integer)
Sheets("LIB").Select
Select Case myType
Case 1
ActiveSheet.Shapes("Liboff1x3wdgtrfr").Select
Selection.Copy
If myValue = 1 Then
Sheets("SLD").Select
ActiveSheet.Paste
Selection.Name = "offtrfr1x3wdgoff1"
Selection.Left = 380
Selection.Top = 642
End If
End Select
Sheet1.Activate
I have two questions about Excel VBA and hope any experts can give me a hint
(1) I wonder how to retrieve automatically the previously saved values from
the combo box and a group of radio buttons whenever I open the workbook?
(2) Everytime I need to insert an object, I copy the object to one worksheet
(named as SLD) from another worksheet (named as Lib) which acts like a
library. However, because of using the function "SELECT", I encounter
"flickering" on the main sheet (named as Sheet1) each time an object is
inserted. Is there any way that I could eliminate this flickering? Your
advices are greatly appreciated.
Public Sub OffshoreTrfr(ByVal myValue As Integer, myType As Integer)
Sheets("LIB").Select
Select Case myType
Case 1
ActiveSheet.Shapes("Liboff1x3wdgtrfr").Select
Selection.Copy
If myValue = 1 Then
Sheets("SLD").Select
ActiveSheet.Paste
Selection.Name = "offtrfr1x3wdgoff1"
Selection.Left = 380
Selection.Top = 642
End If
End Select
Sheet1.Activate