VB Help

[StillLearning]

Hi,
I just a new member here. I need to ask how to use VB in excel?
When open the excel worksheet it automatic go to worksheet I need.

Second thing what book is good in for a new user like me specially in VB in excel.

Thank you

 

[dk]

Hi, and welcome to the board!

Try these steps for doing what you need:-

1. Open the Visual Basic Editor and click Ctrl-R to show the Project Explorer.
2. Locate your project in the Project Explorer window and expand the tree if necessary.
3. Double-click the ThisWorkbook icon and paste this code:-

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
End Sub

Change 'Sheet1' to whatever your sheet is called.

As for good books, I can recommend John Walkenbach's Excel Power Programming - see http://www.j-walk.com/ss/books/index.htm and I've heard that Bill Jelen (Mr Excel) has written some good stuff - see http://www.mrexcel.com/board2/viewforum.php?f=15

 

[StillLearning]

Thank you, for fast reply..

 

[Smitty]

Welcome to the Board!

What Dan said notwithstanding, one of the best ways to learn to use VB in Excel (or any other Office program), is to record some macros and study the code that is generated.

2 caveats here though: VBA will generate a lot of erroneous code as it essentially records your every move, so there will be plenty to pare down. I.E.

ActiveWindow.LargeScroll Down:=1
    Range("A32").Select
    ActiveWindow.LargeScroll Down:=1
    Range("A63").Select
    Selection.End(xlToRight).Select
    Range("E3").Select

Can simply be Range("E3").Select. Although it should be Application.Goto Reference:=['Sheet1'!A1]. (Note that where possible, get rid of select statements).

Second is that there is a lot of code that VBA will not generate that will require you to write some yourself. Searching the board will generally give you a lot of great leads and ideas.

Hope that helps,

Smitty