Blank cell return after each data entry

S

Sudipta Sen

I have a data entry Sheet for loading details to Invoice (sheet 1) and this
data entry sheet loads as soon as file opens. It open with the cells
still with old datas in, is there a way of either the cells being empty when
next data load or actually clearing after use / enter the buttoms (macro) -
OK / Next ?

Rdgs.
Sudipta
 
S

Stefi

Maybe you should create a template from your data entry sheet! A new workbook
opened from a template shall always have empty cells.
--
Regards!
Stefi



„Sudipta Sen†ezt írta:
 
S

Simon Lloyd

Put this in the ThisWorkbook code module and adjust your range(s) t
suit

Code
-------------------
Private Sub Workbook_Open(
Sheets("Sheet1").Range("A1:C1,B3,A10:F12,G10").ClearContent
End Su
-------------------

*How to Save a Workbook Event Macro*
1. *Copy* the macro above placing the cursor to the left of th
code box hold the *CTRL & Left Click,* then *Right Click* selected cod
and *Copy.*
2. Open your Workbook and *Right Click* on any *Worksheet's Name Tab*
3. *Left Click* on *View Code* in the pop up menu.
4. Press *ALT+F11* keys to open the *Visual Basic Editor.*
5. Press *CTRL+R* keys to shift the focus to the *Project Explore
Window*
6. Press the *Down Arrow Key* until *ThisWorkbook* is highlighted i
blue.
7. *Press* the *Enter* key to move the cursor to the *Code Window*
8. *Paste* the macro code using *CTRL+V*
9. *Save* the macro in your Workbook using *CTRL+S

I have a data entry Sheet for loading details to Invoice (sheet 1) an
thi
data entry sheet loads as soon as file opens. It open with the cell
still with old datas in, is there a way of either the cells being empt
whe
next data load or actually clearing after use / enter the buttom
(macro)
OK / Next

Rdgs
Sudipt

--
Simon Lloy

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top