ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform picture (https://www.excelbanter.com/excel-programming/393459-userform-picture.html)

brownti via OfficeKB.com

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


Andy Pope

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




All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com