Hi all, I read from various forums/websites that it appears VB and VBA is highly similar and if I first learn VB then programming in VBA will have practically no problems at all. Is this correct ?
I am a new starter to VB (and VBA), I am reasonably proficent with Excel and Excel formulas but would like to take my Excel expertise to another level. Any suggestion if I should first focus on 1. learning VB language first ? , or 2. just go directly into VBA. One side question and immediate difference I note in VBA and VB is In VB, I can do this Dim string1 As String = "Test" But I cannot do the same in VBA. In VBA, the above will pose an error and it appears it has to be broken up into two parts for it to work as follows:- Dim string1 As String string1 = "Test" Any ideas why ? -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe