Excel cell value with suffix.. 1

[basepointdesignz]

Hi,

I was wondering if there was anyway of adding a suffix to the content of a cell as you type?

Basically, its an invoice and what i would like is that when i type the invoice number in the specified cell, it always has the suffix "-iBPD", but I also want, if possible for the suffix to be dynamic if thats the correct word, so it always appears even as i type. I can get the suffix there with simple VBA but it always seems to appear after i've clicked another cell or even only when i click back on the invoice number cell..

Any ideas?

Cheers,
Paul @ basepoint designz LTD..

basepointdesignzLTD

http://www.bpdesignz.com

 

[AnotherHiggins]

What VBA do you currently have? Are you using the Worksheet_Change event?

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

Hi,

If this is just a DISPLAY issue, format that column CUSTOM
[tt]
#"-iBPD"
[/tt]
No code required.

Skip,

_[red][/red]

 

[basepointdesignz]

Thanks Skip,

That works perfectly - exactly what it says on the tin..

Cheers,
Paul @ basepoint designz ltd..

basepointdesignzltd

http://www.bpdesignz.com

 

[mareng]

i have a column of words that need to be in the format
info_[word].html so prefix and suffix! but the # key only works for numbers.

is it possible to do the same, but with text instead?

ben

 

[mareng]

no worries guys! the world did not end...
its an @ sign

cheers
ben

 

[SkipVought]

Hi,

Please post your question in a new thread.

Skip,

_[red][/red]