prm
10-21-2005, 10:44 AM
Hi,
How do you load data into a form on a Mac? I have the following code and no matter what data on the spreadsheet is selected, the same data keeps coming up. On the form I have the proper sheet and cell selected "=PRACA!A3" and so on but the data does not load. Is there a command missing or a better way of recalling the data from a spreadsheet?
Sub TextBox4_Click()
Range("A1:t99").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("u1:u2"), _
CopyToRange:=Range("v1:ao1"), Unique:=False
Range("w2:ao2").Copy
Sheets("PRACA").Select
Range("A3:s3").Select
Selection.PasteSpecial
Sheets("Select").Select
Range("a2:a99").ClearContents
Range("A2").Select
Application.ScreenUpdating = True
NEXTPRACA1.Show
End Sub
This code works fine on a PC, but not on a Mac. The data is being moved properly, it just doesn't show up on the form.
Any suggestions would be appreciated.
Thank you,
prm
How do you load data into a form on a Mac? I have the following code and no matter what data on the spreadsheet is selected, the same data keeps coming up. On the form I have the proper sheet and cell selected "=PRACA!A3" and so on but the data does not load. Is there a command missing or a better way of recalling the data from a spreadsheet?
Sub TextBox4_Click()
Range("A1:t99").AdvancedFilter _
Action:=xlFilterCopy, _
CriteriaRange:=Range("u1:u2"), _
CopyToRange:=Range("v1:ao1"), Unique:=False
Range("w2:ao2").Copy
Sheets("PRACA").Select
Range("A3:s3").Select
Selection.PasteSpecial
Sheets("Select").Select
Range("a2:a99").ClearContents
Range("A2").Select
Application.ScreenUpdating = True
NEXTPRACA1.Show
End Sub
This code works fine on a PC, but not on a Mac. The data is being moved properly, it just doesn't show up on the form.
Any suggestions would be appreciated.
Thank you,
prm