Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » VBA

VBA

ResolvedVersion 2003

Fri 15 May 2009, 16:34 Delegate Sotirios said...

Sotirios has attended:
Excel VBA Intro Intermediate course

VBA

if you are using an input box to capture data how do you reference the entry to the next available cell available in a worksheet.

Mon 18 May 2009, 09:02 Trainer Stephen said...

RE: VBA

Hi Sotirios

Thank you for your question

I am assuming that you have a list and you wish to find the next blank row. Assuming that cell A1 is within the list then the following will allow you to identify the last row.

intVariable = range("A1").currentregion. rows.count+1

You can then reference that row/cell with

cells(intvariable,1) = value

Hope this is useful

regards

Stephen

Mon 18 May 2009, 21:27 Delegate Sotirios said...

RE: VBA

thanks this is very useful. when this finds that cell entering data is quite simple but I have got stuck trying to compare that value to the last entry - that must always be one more than the previous one.

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Remove spaces in a table

If you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks

View all Access hints and tips

VBA

VBA

RE: VBA

RE: VBA

Access articles

Access tip:

Remove spaces in a table