|
Hi all,
I have a two set of Macros in a workbook. One is to create a command button on a sheet and other macro will run onece the created commond button is clicked.
Macro runs fine. Command button gets created, but when I click the command button to run...
Started by kayyum4u on
, 10 posts
by 3 people.
Answer Snippets (Read the full thread at mrexcel):
ActiveSheet.CodeName).CodeModule
N = .CountOfLines
.InsertLines N + 1, "Private Sub " & NName & "_Click()"
.InsertLines N + 2, vbNewLine
.InsertLines N + 3, vbTab & "MsgBox(" & """" & "Button Clicked &....
|
|
On Wed, 29 Apr 2009 09:48:14 -0700, "Mike" <mikea365h@hotmail.com
In Excel 2007, when I Export a sheet using File/Export and then Import it to
another workbook, the sheet ends up in a Class Module instead of under the
Microsoft Excel Objects where...
Started by Mike on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
As Integer
Dim FName As String
Dim S As String
Dim N As Long
FName = "C:\ThisWorkbook.cls, .CountOfLines
Line Input #FNum, S
' skip headers
For N = 1 To 8
Line Input #FNum, S
Next....
|
|
On Mon, 9 Feb 2009 15:12:02 -0800, fredy <fredy@discussions.microsoft.com
buenas tardes
estas instrucciones como las puedo simplificar?
xy1000.XY17.Picture = LoadPicture(RUTAPLA & "A.WMF")
xy1000.XY18.Picture = LoadPicture(RUTAPLA & "B.WMF")
xy1...
Started by fredy on
, 16 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
+/- asi:
with xy100
for n = 1 to ??????
.controls("xy" & n).picture = loadpicture(??? cells que tengo
Sub Macro1()
rutapla = ActiveWorkbook.Path & "\"
With ActiveSheet
For n = 1 To 4("image" & n).Picture ....
|
Ask your Facebook Friends
