Code for a button to change cell location

M

Michael B

Hi,

Hope you help.

I have a survey on Excel and when completed I want a button which will
change the cell links so that the next time someone goes into it, it will
save their answers on a different line in the Answers worksheeet and not over
the results from the previous survey.


Thanks

Michael.
 
C

Conan Kelly

Mickael B,

I use this line in my code alot to move the selected cell down one row (same
column):

Cells(ActiveCell.Row + 1, ActiveCell.Column).Select

HTH,

Conan
 

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

Similar Threads

I wan to select a button 3
Analyzing Results of a Survey Using Option Buttons 2
Deleting all named ranges that have a workbook scope 3
Creating a Macro? V2 5
Find & Replace Cell Links for Check Boxes 2
Data Entry + Validation 3
VB Random Number Generation/Insertion/NextWorksheet 4
Getting information from several surveys in Access 1

Top