Macro that generates 8 digit random hexa on a given input

[parvezse16]

Hi there,
I'm looking for a macro which generate an 8 digit hexa number on a given input numbers. But before generate a random hexa-number, check if particular input is already in a cell (for example row 12) in column A, corresponding to that cell value (cell 12)in column B will be added in blank cell of both columns other wise generate the hexa-number and add in blank cells with input in separate columns.
Like below Mini-Spreadsheet, If I insert a new input 200321 first it will check the value in Input Cell whether that value exist, If exist than copy corresponding Hexa-Code "MDI93N88" and add it into row 3 of Hexa-Code, and the input value "200321" added to row 3 of Input Column.

Input	Hexa-Code
200321​	MDI93N88
91220​	HD737J93

 

[maabadi]

Why you don't Use Dec2Hex function.

=DEC2HEX(45,8)

you can change 45 with cell address or another number.
And 8 is number of digits you want.

 

[parvezse16]

Thanks

Why you don't Use Dec2Hex function.

=DEC2HEX(45,8)

you can change 45 with cell address or another number.
And 8 is number of digits you want.

But how about check If, there exist a value than why should I generate a number rather I have to add corresponding value
Like, I said here

If I insert a new input 200321 first it will check the value in Input Cell whether that value exist, If exist than copy corresponding Hexa-Code "MDI93N88" and add it into row 3 of Hexa-Code, and the input value "200321" added to row 3 of Input Column.

Input	Hexa-Code
200321​	MDI93N88
91220​	HD737J93
200321	MDI93N88

 

[maabadi]

No need to Check. it show real Hex value correspond with number and it is always same.