basepointdesignz
Programmer
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
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