LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 113
Default explanation of codes in Visual Basic when creating User form

Hi,
I am trying to create a user form in Visual Basic however I'm trying to
teach myself by reading/watching tutorials. (www.contectures.o.ca, etc)
A lot of the instructions I am seeing simply give the code rather than
explain how to actually write one from scratch.
So...
I need to know what each 'term' means so I can understand how the codes work.
Any help is much appreciated :)

One of the first codes is for the Add button
Private Sub cmdAdd_Click()
Dim iRow As Long
Dim ws As Worksheet
Set ws = Worksheets("PartsData")
What does each term refer to?
Dim
iRow
As Long
ws
Set

etc?

Is there a website that has all these definitions?
I don't really want to just copy and paste codes because when my form
doesn't work I can't work out where the error is.

Thank you in advance.
Rachel
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
visual basic help Excel/word form filling in laandmc Excel Discussion (Misc queries) 1 September 25th 08 01:12 PM
Visual Basic CheckBox Codes Su Excel Discussion (Misc queries) 1 January 6th 08 11:50 PM
Visual basic, form does not show date correctly.... Haris Excel Worksheet Functions 6 November 7th 07 02:42 PM
visual basic user form date format dd/mm/yy not mm/dd/yy DarrenO Excel Discussion (Misc queries) 1 March 28th 07 01:56 AM
changing the visual basic in office 2003 to visual studio net bigdaddy3 Excel Discussion (Misc queries) 1 September 13th 05 10:57 AM


All times are GMT +1. The time now is 08:25 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"