I am a supporter of
St. Joseph's hospice.
 If you find this site useful or if it helped you, consider a small donation to
St. Joseph's, please.

Information on
St. Joseph's

JustGiving - Sponsor me now!

 

VBA 05 Input

- Read from spreadsheet cells:
Give a cell a name, for example:

Define_Name

Now you can read or refer to this name from within VBA with
Dim s as string
s = Range("City").Text
Please notice that you can define names which are valid for worksheets only and names which are valid for the whole workbook.

- Read from files:
http://erlandsendata.no

- Avoid reading manual input

[Previous]  [Next]

Sulprobil   Get it done   Contact   Disclaimer   Download