

June 26, 2016

Hello to All my name is Maurizio
It's my problem and this: I want to know what that code is written in VBA, which gives me the ability to recreate the same image once I click on that primacy.
Let me explain better: On an excel sheet I have inserted Sette ImageBoxes representing various Time Forecast types ("Sun, Cloudy, Thunderstorms ...")
So what would I do? It would be to do, for example, a click on the sunshine.
And it should recreate both at Spreadsheet level and Userform level; But only if this is Visible.
One or more images of the same type depends only on where I will click.
I thought I was in degrees to do this, but as I see it is not so.
Thanks for all the help you want to give me in regards to sincere greetings from A.Maurizio

VIP

Trusted Members

June 25, 2016

Hi Maurizio
See if this is what you are looking for.
The macro will copy the image selected in the userform from the Foglio2 sheet and paste it onto the selected cell.
I have set the userform Show Modal property to False so that you can select cells while the form is active.
Hope this helps.


June 26, 2016

Thanks Infinite SunnyKow for this Help, As You Are Always Sublime, Be In Immediate Responses, The Artistic Part of Your Jobs; Thank you very much.
Regarding Your Colleague "David_Ng" honestly speaking I did not understand your joke.
But I would like to point out that, in my opinion, whatever the request for disclosure of the VBA; Rather than Vb.6 I have Java that is etc ...!
The important thing and try to give a sense to your form of thought in a few words to be there.
I think in addition to that: It does not matter much to you to create the Tombol Game; Rather than the Game of the Checker or Chess which they are.
The important thing is to leave an indelible mark for the Boys of the Future.
For here it does not matter much to you, either my flour coat of mine I have with all of you, the important thing and leave a track or something important for the new Futura generation; Oh no ?
However be Thank you also for your sincere intervention, Greetings to Both of A.Maurizio
1 Guest(s)
