Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation query
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation query
In WHICH group do you want an answer?
-- Don Guillett Microsoft MVP Excel SalesAid Software "teepee" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation query
Try something like this...
UserForm1.Controls("WindowsMediaPlayer" & Range("A1").Value).Controls.currentPosition Note: That should all be on one line but I expect newsreaders will wrap the text because of its length. -- Rick (MVP - Excel) "teepee" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
concatenation query
"Rick Rothstein" wrote in message ... Try something like this... UserForm1.Controls("WindowsMediaPlayer" & Range("A1").Value).Controls.currentPosition Worked a treat. Many thanks Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Concatenation help | Excel Worksheet Functions | |||
concatenation query | New Users to Excel | |||
Concatenation query | Excel Discussion (Misc queries) | |||
Concatenation Help | Excel Worksheet Functions | |||
Concatenation | Excel Programming |