Thanks Lisa, thats an interesting solution.
So far I'm OK with one picture on each sheet, but I will consider your way of doing it, if I'm going to do further changes!
Torstein
________________________________
Fra: Green <1z@compuserve.com>
Til: ExcelVBA@yahoogroups.com
Sendt: Onsdag, 3. juli 2013 16.13
Emne: Re: Vedr: [ExcelVBA] Re: loop with userform
Torstein,
You can put pictures on a userform. Do you need the users to see the pictures on the sheet? How about presenting the pictures one at a time on the userform and asking them to fill in checkboxes 1 - 5.
The userform could have Previous - Next and Cancel buttons. The answers could be stored mabe in a global array or probably better on the sheet itself.
Lisa
Sent: Wed, Jul 3, 2013 2:32 pm
Subject: Vedr: [ExcelVBA] Re: loop with userform
Thank you Steve, your explanation gave me some new knowledge about userforms.
I'ts hard for me to describe "my problem" in my poor english, but my concern was
wether the loop continued running when the code from the commandbutton was
started.
And to Derek and your confusion:
I want to show the user 25 pictures each on one sheet (by using a loop) , and
have them giving an answer 1-5 based on that picture.
I have made that using an inputbox, and my question was how to replace that
inputbox with a userform which is easier to adapt.
Perhaps I have increased the confusion - altogether I have learned something
about userforms and that I have to do further studies on them!
regards
Torstein
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (12) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar