Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,489
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Picture in a UserForm Howard31 Excel Discussion (Misc queries) 1 December 20th 08 03:27 PM
How to get a picture on a userform? Alex Excel Programming 0 March 27th 06 12:07 AM
How to get a picture on a userform? sebastienm Excel Programming 0 March 26th 06 11:58 PM
Usin Picture on userform Momo Excel Programming 3 March 4th 05 04:15 PM
displaying picture in a userform Todd Huttenstine[_3_] Excel Programming 1 January 28th 04 02:42 AM


All times are GMT +1. The time now is 04:59 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"