Passing values to a string

R

Risky Dave

Hi,

I have a unique identifier in the format:

ABC-R-<number>

Where only <number> changes .

As part of a search capability, the user is able to enter the specific value
of <number> that they are looking for - this is in an adjacet cell to the
ABC-R- text.

What I want to do is concatenate ABC-R- and the user-defined <number> then
pass it to a String which I can then use to search the data arrays. What is
the format for this, or can't I do it?

If not, any suggestions on how I can pass a user-defined value to a variable?

TIA

Dave
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

i = row number of last occurance of duplicate string Column A 4
looking for true result if number is a % 1
Passing a string to Case statement 4
Dim As Range Object 6
Get an enum value assigned with *concatenated* string 1
Hyperlink calls macro passing argument 3
Formatting Sheet 5
passing values from form to module 5

Top