|
Sanskrit Work in Excel -- Ashok Mathur --
I would like to know if there is any method of programtically (ie VBA coding) of changing the the display properties of two built in boxes in an Excel spreadsheet. I am presently working with Sanskrit text in Excel. If you want to torture yourself, that is an excellent method. By now I can manipulate most things. However, whenever you are in any cell in an spreadsheet, Excel dispalys its contents in a , what I am labelling as "Input box" right next to the "fx" sign. While the font in the cell is in Sanskrit, and displays properly, the text in the Input box is always in a Roman font(Default font of Excel). How can I change the font to be the font of the cell? Another related problem is that, for useful display the font size of SD TT Surekh, or other sanskrit fonts, should be size 18 (equivalent of saying that font of roman text should be size 10) for usual display. So is it possible to set the font size also? The left hand margin of Excel dispalys a "GOTO/ Where I am" box. By default it dispalys the address of the cell you are in. However by typing a cell address, you can go there. If the Cell has an associated name attached with it, it gets displayed in preference to the address and you can open a drop down list of Names to go there. Can the font of this box be set to a Sanskrit font so that the names can be dispalyed in sanskrit? Thanks in anticipation. Regards Ashok |