Posts by gixxer

:puzzled:

Any other suggestions are greatly appreciated.

thanx
edwin

Worked in both for me

thanx

thank you....
any idea for Word??

:cheers:

Is it possible to write a code that will close Excel or Word completely? Currently I am only able to close the Workbook or Document, not the whole program.

thanx
edwin:o2

Excellent, I know the OnKey function doesnt work in Word though....just that one to go.
thankx:cheers:

I cannot for the life of me figure out how to do this.

Please help me I'm Dyin' over here

:smash::smash:

Thanks for the link but there was nothing there about disabling the Esc Key.

Help Please I'm Dyin' over here:smash:

I need to disable the Esc Key when I start a Word Document

Private Sub Document_Open()

End Sub

Is this where I put the code, & what code do I use??

thanx
edwin

How can I disable the Escape Key in both Word & Excel VBA

Edwin:tongue:

Is it possible to format a text box so that if I enter 1 the it shows 1st, 2 shows 2nd etc.

thanx
edwin
:smash:

I need to fromat the Textboxes on a form for the following:
Phone numbers incuding area code in brackets
Social security numbers
and another to automatically show all letters as capital letters.

Any help is greatly appreciated

thanx
edwin :duh:

Can anyone post a sample code for this type of form...I need just a little bit of help here

Hey Andy,

Thats just what Ive been looking for

thanx
edwin

I have a Multipage Form....how can I get the Form to load up at a specific page and hi-lighting the contents of a specific text box?

PS how do I change "MY MOOD" on the left over here
<-----
I'm not always frustrated :beergrin:

I purchased the password for the code but his Form is geared towards any table, mine is a specific table. The major problem Im having is that I get a Type Mismatch error in the part of the code that sends the data from the Data Array to the spreadsheet.

That J-Walk form is real nice and does almost all I need it to, however I am planning on selling the spreadsheet I'm building so it would not be appropriate to use it.

Thanx

I created a Form that will input Data into an Excel Table. I have too much data to use the built in Data Form that comes with Excel but I'm havin some problems with code for sending data from the spreadsheet to the Data Array & vice versa. Any help greatly appreciated.:smash:

Thanx Dennis,

works like a charm :thumbcoo:

I have a form that ads information to an Excel Database but I keep getting a Type Mismatch error in my code. What exactly does that mean, what could be cause and how do I fix it?:puzzled:

I created a UserForm and need to format the textboxes so that as the user is inputting the data (Percent, Currency etc) the data showa as percent & currency. Also, should I have the data linked to the Excel worksheet via the controlsource option or have it load in the Form Intialize procedure??

thanx
edwin:smash: