Mike Callahan
New Member
- Joined
- Jun 16, 2008
- Messages
- 17
Lotus was so easy to pull a field name value out a spreadsheet function with a macro, re-work the value in the macro, then change the value. Ex:
IF D:A1>5 LET PRICE =BUDGET*PRICE1
This was all done on the spreadsheet where BUDGET was a data base result, PRICE1 was a field, then the result was a new value for PRICE. How do you do that with Visual Basic and Excel?
If anyone has the time, you will make my day
IF D:A1>5 LET PRICE =BUDGET*PRICE1
This was all done on the spreadsheet where BUDGET was a data base result, PRICE1 was a field, then the result was a new value for PRICE. How do you do that with Visual Basic and Excel?
If anyone has the time, you will make my day