teachround
04-23-2008, 03:31 AM
I have a spreadsheet for a project which creates invoices for a warehouse. in the spreadsheet there are a series of vlookups and everything works fine when I run macros using buttons in excel.
The project requires me to create a VB form and run everything in VB, so the user never actually sees the spreadsheet.
When I run the recorded macro using a button on my VN form, to bring in a new record to process, from a different sheet, all the formulas delete themselves from the cells below where the record is pasted in.
The project requires me to create a VB form and run everything in VB, so the user never actually sees the spreadsheet.
When I run the recorded macro using a button on my VN form, to bring in a new record to process, from a different sheet, all the formulas delete themselves from the cells below where the record is pasted in.