Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform picture
I need some help with userforms. I have two forms, the first one, Userform 1,
has a picture and a button on it. The second one, Userform 2, has 10 pictures on it with corresponding radio buttons. When you click the button on Userform1 it displays Userform2 then when a radio button is selected, i want the corresponding picture to show up in the Userform1 picture box. How can i do this without writing code with the location of each picture? Is that possible? -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform picture
Hi,
Something like this in the OptionButton click event Private Sub OptionButton1_Click() Userform1.Image1.picture = Userform2.Image1.picture End Sub Change userform2 image control reference to suit option button being clicked. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "brownti via OfficeKB.com" <u31540@uwe wrote in message news:754614707fa30@uwe... I need some help with userforms. I have two forms, the first one, Userform 1, has a picture and a button on it. The second one, Userform 2, has 10 pictures on it with corresponding radio buttons. When you click the button on Userform1 it displays Userform2 then when a radio button is selected, i want the corresponding picture to show up in the Userform1 picture box. How can i do this without writing code with the location of each picture? Is that possible? -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picture in a UserForm | Excel Discussion (Misc queries) | |||
How to get a picture on a userform? | Excel Programming | |||
How to get a picture on a userform? | Excel Programming | |||
Usin Picture on userform | Excel Programming | |||
displaying picture in a userform | Excel Programming |