Posted to microsoft.public.excel.misc

teepee[_3_] teepee[_3_] is offline

external usenet poster

Posts: 107

concatenation question

Hello

I'm guessing this isn't allowed but I'd welcome confirmation

Can one concatenate a variable into a VBA command

So for example

instead of userform1. windowsmediaplayer1.controls.currentposition

could you have

userform1. windowsmediaplayer & ("range a1") & .controls.currentposition

If so what would the correct syntax be?

Many thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Concatenation	MichaelS	Excel Discussion (Misc queries)	8	September 11th 08 07:54 AM
Help with Concatenation	alex	Excel Worksheet Functions	3	August 28th 07 06:09 PM
Concatenation	Harry	Excel Worksheet Functions	2	July 17th 06 07:17 PM
Concatenation question	~C	Excel Worksheet Functions	1	February 2nd 06 10:14 PM
Concatenation Help	Henry	Excel Worksheet Functions	4	December 15th 04 08:21 PM

All times are GMT +1. The time now is 11:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us