Solved Use VBA to stop formulas from being deleted

August 25, 2018 at 22:41:16
Specs: Android
I have formulas in that if I select the client then the terms,address,client name and vat number populate automatically. But if I say save and new invoice it clears the formulas also I just need it to clear the data

See More: Use VBA to stop formulas from being deleted

Reply ↓  Report •

#1
August 26, 2018 at 06:41:55
Please keep in mind that we cannot see your workbook from where we are sitting. Therefore we have no idea how your workbook works or how the data gets filled in based on the client's name. You need to provide some more details such as how the data ends up in the fields that you are concerned with. Is it done via the formulas or is it done via VBA, etc.

The more details you provided the easier it is for us to help you. Perhaps including a copy of the code or a copy of some of the formulas would help.

If you are going to include any code your response, please click on the following How To link and read the instructions on how to post VBA code in this forum. Thanks.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
August 27, 2018 at 00:42:34
✔ Best Answer
Hi, I solved this, I have a VBA code that clears all the cells, but I actually only need it to clear E4 as I choose E4 and then it populates the rest of the info into the other cells where the vlookup formulas are, so all I did was take out the other part of the VBA Code.

Reply ↓  Report •

#3
August 27, 2018 at 05:43:05
That was exactly where my head went when you asked your question, but not knowing how your workbook and/or code was set up, I didn't want to say "Just clear the client's name."

I'm glad you figured it out.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question