Hi,
Is there anyway to automatically set the style to 'input' when I enter a number. The only time I enter a number into a cell it is an input but I can't figure out how to get Excel to automatically format it once entered.
Thanks
Hi,
Is there anyway to automatically set the style to 'input' when I enter a number. The only time I enter a number into a cell it is an input but I can't figure out how to get Excel to automatically format it once entered.
Thanks
Be aware that the Undo stack gets flushed if code makes a change to the worksheet.Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
Perfect thanks, does this require a lot of processing power? i.e. is it scanning the whole sheet everytime I add a cell, or is it just checking the new cell?
It responds to data entry (via code or manually) on a worksheet, and looks only at the changed cells.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks