Just a very quick question:

Is it possible to insert a wordart inside a userform ??

If yes how??

thanks

fulvio

Hi,

You can insert a picture of the wordart in the userform.
Have a look here.
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy

furbiuzzu wrote:
Just a very quick question:

Is it possible to insert a wordart inside a userform ??

If yes how??

thanks

fulvio


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy Pope ha scritto:

Hi,

You can insert a picture of the wordart in the userform.
Have a look here.
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy



really really thanks.
everything i need is in your superb demo excel sheet.
just need to stuy and learn it right now....

i've some problems can i "call u back" ??

If you need further assistance just post your question(s).

Cheers
Andy

furbiuzzu wrote:
Andy Pope ha scritto:


Hi,

You can insert a picture of the wordart in the userform.
Have a look here.
http://www.andypope.info/vba/userformdraw.htm

Cheers
Andy




really really thanks.
everything i need is in your superb demo excel sheet.
just need to stuy and learn it right now....

i've some problems can i "call u back" ??


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Andy Pope ha scritto:

If you need further assistance just post your question(s).

Cheers
Andy


i've imported all needed code in my existing userform
now i'll try to explain you what i've to do with wordarts:

Each time i open the userform i want to create a variable number of
wordarts, let's say between 10 and 40, depending on the numbers of data
i've stored inside my Sheet1.
Each WordArt "caption" is inside a specific cell.

so, here are my problems:

1) inside my userform i have other pictures, when i click on the button
ehich creates the word art, other pictures disappera frome the screen

2) how can i create more than one (or better , a fixed number of) word
art inside my form

3) Do this objects behave like pictures? i mean with all their
properties (.top, .left etc etc etc.)


PS.

i don't know if i can handle what i'm going to learn from you.....


really thanks.
fulvio

Ok, this is going to get to detail for a ng thread. So email direct with
what you have so far and we can take it from there.

Cheers
Andy

furbiuzzu wrote:
Andy Pope ha scritto:


If you need further assistance just post your question(s).

Cheers
Andy



i've imported all needed code in my existing userform
now i'll try to explain you what i've to do with wordarts:

Each time i open the userform i want to create a variable number of
wordarts, let's say between 10 and 40, depending on the numbers of data
i've stored inside my Sheet1.
Each WordArt "caption" is inside a specific cell.

so, here are my problems:

1) inside my userform i have other pictures, when i click on the button
ehich creates the word art, other pictures disappera frome the screen

2) how can i create more than one (or better , a fixed number of) word
art inside my form

3) Do this objects behave like pictures? i mean with all their
properties (.top, .left etc etc etc.)


PS.

i don't know if i can handle what i'm going to learn from you.....


really thanks.
fulvio


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info