VBA novice: new to userform & VB editing...
 

Dear All.

Can someone point me towards simple explanations or sets of examples of all
VBA code? I am wanting to:

1) open workbook to view existing list data within a userform,
2) update or add information into existing records
3) add additional records
4) search for specific records

I am completely new to MS VBA and spent my misguided youth using Lotus
Approach - so the concepts of databasing are familiar, but the MS methodology
escapes me!!!

Thank you for your assistance, regards,

D.

VBA novice: new to userform & VB editing...
 

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


Here are some other sources of information:

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy


"Dexxterr" wrote:

Dear All.

Can someone point me towards simple explanations or sets of examples of all
VBA code? I am wanting to:

1) open workbook to view existing list data within a userform,
2) update or add information into existing records
3) add additional records
4) search for specific records

I am completely new to MS VBA and spent my misguided youth using Lotus
Approach - so the concepts of databasing are familiar, but the MS methodology
escapes me!!!

Thank you for your assistance, regards,

D.

VBA novice: new to userform & VB editing...
 

Tom

Thank you for those - I'll get reading!

Kind regards,

D.



"Tom Ogilvy" wrote:

http://j-walk.com/ss/excel/tips/tip84.htm

See this tutorial here
http://www.dicks-blog.com/excel/2004...g_userfor.html

http://support.microsoft.com/default...b;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel


XL97: How to Use a UserForm for Entering Data (Q161514)
http://support.microsoft.com/?id=161514

XL2000: How to Use a UserForm for Entering Data (Q213749)
http://support.microsoft.com/?id=213749


Here are some other sources of information:

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.


http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy


"Dexxterr" wrote:

Dear All.

Can someone point me towards simple explanations or sets of examples of all
VBA code? I am wanting to:

1) open workbook to view existing list data within a userform,
2) update or add information into existing records
3) add additional records
4) search for specific records

I am completely new to MS VBA and spent my misguided youth using Lotus
Approach - so the concepts of databasing are familiar, but the MS methodology
escapes me!!!

Thank you for your assistance, regards,

D.