update an existing macro

  • Thread starter Thread starter sam
  • Start date Start date
S

sam

I have an excel form with existing macros that I need to update.

The idea is to auto populate one field based on values selected in two other
fields.

Lets say there are 3 fields A, B, C with specific values listed as a drop
down menu.

A: Hello, What, Going, There
B: Did, Jolly, Cool, Tomorrow
C: Discrepancy

so lets say for eg, If Hello and Did are selected, C will remain blank

If Hello, Jolly are selected, C will populate Discrepancy
(assume Hello has lower rating then Jolly)

If What and Did are selected, C will remain blank.

The Idea is, values in A and B column are text values and they have ratings.

If value in A has lower rating then value in B then populate 'discrepancy'
in C
If value in A has higher rating then value in B then no value is populated
in C
If A and B have the same values then no value is populated in C

And so on.. I hope it is clear.

Thanks in Advance
 
Sorry, but this newsgroup is for questions about macros in Access, the
database product that's part of Office Professional.

Macros in Excel are VBA code, whereas they're something completely different
in Access.

You'd be best off reposting your question to a newsgroup related to Excel.
 
Back
Top