Anyone know Visual Basic???

SarieP

I'm doing a spreadsheet for work that requires stuff in Visual Basic that I'm totally unfamiliar with.  Do any of you know it enough to help me?

[Deleted User]

I've taken some classes in it, what exactly do you need help with?

ac_in_dc

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.

ac_in_dc

what's your question?

SarieP

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?

SarieP

Basically I want the same rule to apply to multiple cells and currently it works for just C3.

ac_in_dc

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.

ac_in_dc

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.

ac_in_dc

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.

SarieP

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.

ac_in_dc

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.

SarieP

Oh this is so frustrating. The data validation has already been changed.  There is a different one in each cell.

ac_in_dc

Well, what did you do to make the drop-down correspond to c3?

SarieP

=VLOOKUP(F3, PicTable, 2, FALSE)which is in cell C3=VLOOKUP(F5, PicTable, 2, FALSE)which is in cell C5C3 works but C5 does not.

ac_in_dc

hmm...I have to go to a meeting. I'm a little bit confused as to what you're trying to do. good luck.