Quickie !  How to refer to a Name in VBA

Posted on 2011-02-16
Last Modified: 2012-05-11
Example: This is very easy ... if I explain it correctly!

I have a value "J" stored in cell A1. (This value will change!)
I then define a NAME so that cell A1 is named "Initial"

In VBA code I want to set strInitial =   the value in name "Initial"
See below.  

dim strInitial as string
    strInitial = ?????

What is the correct syntax so that strInitial will hold the value of "Initial"
Question by:Patrick O'Dea
LVL 50

Accepted Solution

teylyn earned 333 total points
ID: 34911458


LVL 50

Expert Comment

ID: 34911467
Or, to complete your code lines

dim strInitial as string
    strInitial = Range.("Initial")
LVL 50

Assisted Solution

teylyn earned 333 total points
ID: 34911483
Sorry, not quite awake yet. no dot!!

Dim strInitial As String
    strInitial = Range("Initial")
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

LVL 33

Assisted Solution

jppinto earned 167 total points
ID: 34911508

Author Closing Comment

by:Patrick O'Dea
ID: 34911543
Thanks all.
I said it was a quickie!

I will check the links out jppinto
LVL 45

Expert Comment

ID: 34911839
This is much simpler and will also work:

dim strInitial as string
strInitial = [Initial]

The [] square brackets just mean evaluate.


Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This article is the result of a quest to better understand Task Scheduler 2.0 and all the newer objects available in vbscript in this version over  the limited options we had scripting in Task Scheduler 1.0.  As I started my journey of knowledge I f…
Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now