Combo Box command other sheets

[davidhall80]

I am try to make my combo Box Carry out actions on other sheets. When I get to the "Range("a1").select, it craps out. Is it possible for a combo box to make references to other sheets



Private Sub ComboBox1_Change()


If ComboBox1.Value = 1 Then
Rows("7:20").Select
Selection.EntireRow.Hidden = True
Rows("10:15").Select
Selection.EntireRow.Hidden = False
Range("C14").Select
Sheets("sheet2").Select

Range("a1").Select


Selection.EntireRow.Hidden = True
Rows("10:15").Select
Selection.EntireRow.Hidden = False
Range("C14").Select

End If



End Sub

 

[dave3009]

If you wanted to be an expert this might help you

http://www.mrexcel.com/learnexcel.shtml

My guess is you'd learn everything about Excel by doing this.

Try your local book store for any Excel VBA book, all authors take a different approach so you might want to try one or two. The first one I bought was 'Excel VBA Programming for Dummies' by John Walkenbach. It's basic but good for starting

Kind Regards

Dave

 

[erik.van.geit]

I've been studying the code all night. thank you very much for taking the time to explain it to me. i am very eager to learn visual basic. would you recommend any reading material for my personal growth?????

Perhaps obvious, but don't forget to read the VBA-helpfiles !!!

several ways to use them:
click F1 while having your cursos on a "key"word in VBAcode
type keywords to do a search
reconstruct the samples, change some details to learn how it works
browse the contents-tree

also check out the Recommended Add-ins and Links

greetings
Erik