Need some Basic Help

  • Thread starter Thread starter shboom
  • Start date Start date
S

shboom

I have recently had to switch from QuattroPro(Corel) t
Excel(MicroSoft). All I'm looking to do is create a simple spreadshee
into which myself or anyone else in the office can enter 5 or 6 piece
of information. This compilation would grow as various people inpu
their data. I need to create a macro that will prompt the user fo
their information, moving from cell to cell as that info. is added int
the spreadsheet. It was a breeze in QuattroPro. I'm finding it almos
impossible with Excel. What am I doing wrong????? :confused
 
Hi
Have a look at Data/Forms for your inputting of information
and you might also consider looking under Tools at
Protection/Sheet protection for closing cells to future
changes.


HTH
Michael
 
shboom said:
I have recently had to switch from QuattroPro(Corel) to
Excel(MicroSoft). All I'm looking to do is create a simple spreadsheet
into which myself or anyone else in the office can enter 5 or 6 pieces
of information. This compilation would grow as various people input
their data. I need to create a macro that will prompt the user for
their information, moving from cell to cell as that info. is added into
the spreadsheet. It was a breeze in QuattroPro. I'm finding it almost
impossible with Excel. What am I doing wrong????? :confused:
Click to expand...

If you mean you were using macros like

{?}~{r}{?}~{r}{?}~{r}{?}~{r}{?}~{end}{l}{d}{file-save}

or something like that (I don't recall the precise QP syntax, but I'm
guessing it's still close to 123 classic syntax), then there's nothing
really equivalent in Excel. You could use a workbook_Open event handler
macro to select the next 'record' to be entered as the workbook is opened,
then use Worksheet_Change and Worksheet_SelectionChange event handler macros
to check where you've just entered data or where you've moved to, and
highlight the entire corresponding 'record', but it may be much simpler just
to have the other users enter their data without macros.
 
Back
Top