Does you computer have VB help? It's *really* useful, I've been able to teach myself everything I need to know about VB based on the help section in excel.
Ok I'm still working on the same spreadsheet where I'm trying to make arrows appear in a drop down list. I have made a reference to the arrow pictures so that when the user selects certain text, the arrows appear in the field they are supposed to. The first field that an arrow is supposed to appear is C3. I also need them to appear in other cells as well, based on a different selection. Can I input multiple ranges in VB to make the arrows appear in the other cells?
Range("D3").Value=Range("C3").Valuewould make whatever is in cell c3 show up in cell d3. If the particular workbook and sheet you're in is already active.
If you want to do it for a shiit-ton of cells you can write a loop (for, next) and reference the cells by row & column. You should be able to look that stuff up in help. But I'd only try this if you have programming experience...it's probably not worth the time to learn otherwise.
oh, or you could doRange("D3:J3").Value=Range("C3").ValueThat would put whatever's in C3 in D3 thru J3you could also do "C4:C40" or whatever obviously.
ac, I don't want to replicate the value in the cell, only the rule. I have saved the arrows as pictures. When the user selects the text in the drop down menu, the corresponding arrow appears in C3. The user will select different text for the next cell and that corresponding arrow should appear, which is what I'm having trouble with. I know nothing about VB and happened to find enough online to get it to work for C3, but not additional cells in the same worksheet.
So what you need to change is the data validation or whatever is putting that arrow in c3. Hit record macros and do whatever you need to do to data validation or whatever you're using in the drop down that assigns an arrow to c3. Change this to c4 or whatever while the macro is recording. Stop recording your macro and then go to the visual basic editor. Then you'll have a code snippet to work with which you should be able to replicate, edit, etc. as you need.
Re: Anyone know Visual Basic???