help please! I really need to figure this out

[d0wnt0wn]

I have tried leaving a post on this in another thread but i cant seem to get any responce to this.... sorry it is very important that I get this done

i wouldl like to have some code that works like this....

sheet 1 cell a1 if i enter a number from 1 to 10 I copy cell b1-b10 (depending on which number i put in a1) on sheet 2 and paste it into B1 on sheet 1

seems like it should be easy to me but i cant seem to get any responces on it any help would be greatly appreciated.... and I have to use code for this as a vlookup will not get me what i want

 

[Smitty]

With the code ammendment that I posted, the code will copy Sheet1, cell B & the value entered in A1 to the corresponding cell in Sheet2).

I.E. Enter 5 in A1 and Sheet1, cell B5 will be copied to Sheet2, B5.

Isn't that what you wanted or am I missing it altogether?

Smitty

 

[d0wnt0wn]

hi smitty... ok the code works as you say it does but its not really what I am trying to do here... i will try and explain it as clearly as possible

on sheet 1 in column A i would like to have list boxes from a1 to a10

the list boxes will contain names of pictures.... or i can just use numbers from 1 to 10 say as I will have ten pictures

if i select one of the picture names in the list box then i want the cell on sheet2 that that particular picture is in to paste to b1 on sheet1

i have the pictures inserted into comments so that when you copy paste the cell... the comment comes with it and shows the picture.... i dunno.. maybe there is an easier way to call pictures up... problem is i only get a chance to work with excel in the winter months and by the time I start doing it again i have forgotten most of what i learned the year before... this seems like it should be fairly simple to me but my mind is drawing a blank.

 

[d0wnt0wn]

can anyone help with this????????

 

[tusharm]

You need to figure out what it is that you are trying to do. First you write you have a number in A1. Now, you write you have textboxes (plural!). Which is it?

Further along you use the singular in "select one of the picture names in the list box." So, what is really going on?

Another approach you may want to consider is to put all the pictures on Sheet1 in the beginning setting all their visible attributes to false. Then, based on whatever selection is made however and whereever set that particular image's visible attribute to true ensuring that all others are false.

hi smitty... ok the code works as you say it does but its not really what I am trying to do here... i will try and explain it as clearly as possible

on sheet 1 in column A i would like to have list boxes from a1 to a10

the list boxes will contain names of pictures.... or i can just use numbers from 1 to 10 say as I will have ten pictures

if i select one of the picture names in the list box then i want the cell on sheet2 that that particular picture is in to paste to b1 on sheet1

i have the pictures inserted into comments so that when you copy paste the cell... the comment comes with it and shows the picture.... i dunno.. maybe there is an easier way to call pictures up... problem is i only get a chance to work with excel in the winter months and by the time I start doing it again i have forgotten most of what i learned the year before... this seems like it should be fairly simple to me but my mind is drawing a blank.

 

[PaddyD]

as per tushar's post, the specs aren't entirely clear, but you may be interested in Andy Pope's picture viewer:

http://www.andypope.info/fun/picviewer.htm