Forum Home
Press F1
 
Thread ID: 33618 2003-05-21 03:20:00 Excel - Limiting amount of text in a field Kame (312) Press F1
Post ID Timestamp Content User
146116 2003-05-22 02:04:00 I tried =CHAR(x) to see if it works and it does, but Bell (the old ctrl-g) does not go "ding".
Shame.
Showing my age.
robo.
robo (205)
146117 2003-05-22 02:12:00 Found the Answer! VB is very useful.

Just wondering, can I have two functions in one cell? e.g. One that tells me I'm over and beeps?
Kame (312)
146118 2003-05-22 02:34:00 You really are showing your age, here's something for you so you can be reminded how BELL goes. Open up command prompt and type "echo ^G" ahhh the old age. Glad I'm not with it!

^G = CTRL G
Kame (312)
146119 2003-05-22 02:35:00 Not sure what you mean. Regular functions can be used and nested in if statements if desired. Not sure what the answer is if you are calling VB routines.
robo.
robo (205)
146120 2003-05-22 03:00:00 www.j-walk.com

in fact the site is good for excel users has a lot of tips but quite outdated. I haven't tested it if it works though but will give it a go.
Kame (312)
1 2