View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
teepee[_3_] teepee[_3_] is offline
external usenet poster
 
Posts: 107
Default 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