Unique ID Number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

StompS - 17 Jan 2006 16:48 GMT

I would to assign a unique (sequential) ID # to a cell when that cell is
selected somehow. Once that number is selected then the next time a cell
formatted that way is selected, it gets the next number in the sequence.
Thank you.

Reply to this Message

JE McGimpsey - 17 Jan 2006 17:14 GMT

Take a look here for sequential numbers:

http://www.mcgimpsey.com/excel/sequentialnums.html

You don't say what "cell formatted that way" means (e.g., Numberformat?
Font characteristics? Cell background?), you may be able to use a
Worksheet_SelectionChange() event:

Private Sub Worksheet_SelectionChange( _
ByVal Target As Excel.Range)
With ActiveCell
If .Interior.ColorIndex = 3 Then _
.Value = NextSeqNumber
End With
End Sub

> I would to assign a unique (sequential) ID # to a cell when that cell is
> selected somehow. Once that number is selected then the next time a cell
> formatted that way is selected, it gets the next number in the sequence.
> Thank you.

Reply to this Message

StompS - 17 Jan 2006 17:36 GMT

Sorry,

What I meant was that, cells in that column, which represent a unique ID
number, and would be somehow formatted so Excel knows that those are the
cells that need this option. This is just to give a unique number to each
set of data.....

> Take a look here for sequential numbers:
>
[quoted text clipped - 16 lines]
>> formatted that way is selected, it gets the next number in the sequence.
>> Thank you.

Reply to this Message