Hyperlinks

S

simplymidori

Let's say I have a list of hyperlinks in a column

Column A:
Link: "ftp://upload:[email protected]/spot%20viewer/" & [number] & ".wmv"

Column B: [number]

I want column [numbers] as text to display.

Thanks in advance.
 
J

Jeanette Cunningham

Try this:

Me.BTextBox = Me.ATextBox & Me.BTextBox & ".wmv

BTextBox is the name of the control on your form that is bound to field B
[number]
ATextBox is the name of the control on your form that is bound to field a
[number]

Jeanette Cunningham
 

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

Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Excel Macro to hyperlink an archived worksheet to an index page 0
SUM - IF - AND 7
hyperlink syntax 1
using VBA to populate a hyperlink field 2
Hiding a column of hyperlinks behind a column of numbers 2
Excel Concatenate with line breaks but ignore blank cells 3
Filling in fields to a partially complete record in a table using a form 0

Top