|
Formula for using SUM feature is fill in table
I have two columns in my form. When the staff inputs their information into
the forms, I want each column to be added. B2:B10 and C2:C10. How can I
accomplish this with a fill in form?
Thanks in advance
...
|
2 |
13.01.2006 17:36:36 |
|
|
Collapse a row if value is null
I have a word doc with a table that I'd like to expand/collapse
depending on whether there are any values in the rows. It's actually a
mail merge document that pulls values from a text file generated from a
VFP application.
.....Date-------------------Amount **Column Headers**
<<Date1>>----<<AMOUNT1>>
<<Date2>>----<<AMOUNT2>>
<<Date3>...
|
3 |
21.01.2006 10:22:15 |
|
|
adding custom GUI to Word
I'm working on a Word add-in that will require a custom GUI. I'm doing all
of the work in C++ (I wrote wrapper classes to make the appropriate COM calls
for the Word object model). I know you can create userforms with VBA, but
can I do the same with C++? Basically, I don't see how to get the Windows
messages from Word to be sent to my own event handlers inside the separate
dll. I kno...
|
2 |
19.01.2006 17:38:45 |
|
|
Free mp3's
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<TITLE></TITLE>
</HEAD>
<BODY>
<P>And much more that that!</P>
<P><A href="http://forum.saait.net/">http://forum.saait.net/</A></P>
<P>This site offers free and legal mp3's, software, movies, games.<BR>They also
have a l...
|
1 |
18.01.2006 07:27:35 |
|
|
Form to select textblock for printing
I like to create an online form that allows me to enter Text into some
fields and select some checkboxes. When I print, only the text associated
with the checked checkboxes is supposed to print, but not the checkboxes.
This is how the document template (form) should look like (fields are shown
with brakets):
[address]
Salutation [lastname],
Some text ...
[x] text block 1
[ ] te...
|
3 |
17.01.2006 14:04:29 |
|
|
Setting the focus to a textbox
Hi
VB 6.3
I must be going blind:
I know I can use .SetFocus programmatically, but is there a way to set it as
the default in the Properities list?
Thanks
Dave F.
...
|
3 |
13.01.2006 03:51:48 |
|
|
Auto complete drop down bookmark
I have a form with a drop down book mark. I need to populate it from a MS
Access database called SalesReps.mdb. Once I get that to populate, the sales
people will click on the proper sales rep and it will fill in the address,
city, state, zip and phone number for the sales rep in other bookmarks in
the form.
I can not get this to work. Can anyone help me with this project?
Thanks in ad...
|
7 |
13.01.2006 00:32:53 |
|
|
outlook calendar entry
I would like a date on my word form to add a reminder to a user's outlook
calendar 80 days beyond the date on the word form. How would I do this using
vb or vbscript behind the word form?...
|
2 |
06.01.2006 20:20:02 |
|
|
Userform to display index marked { XE"..." } fields
I am a reasonably competent word user, but new to VBA. I index words a lot in
my documents and I want to design a simple userform that has a listbox which
shows all the words which as index marked in { XE"..." } fields.
I have got so far as the design of the box, but can't find any information
online as to how to link the listbox to the list of words marked in { XE"..."
} fields.
Ca...
|
6 |
05.01.2006 23:34:50 |
|
|
Basic MsgBox-style userform from inside a macro
Can someone outline the basic steps necessary to create a user form
that I can invoke from inside a macro that will look similar to a
MsgBox but where I can define buttons other than Yes, No, Cancel?
How do I create the suer form -- that is, where does it go?
How do I invoke it from the macro?
How do I retrieve the results depending on what buttion the user
selects?
I just need help...
|
4 |
05.01.2006 13:46:16 |
|
|
Bookmark in text form field
I have an Autonew script that inserts a text number into a table row. I want
the number to go into a text form field. When I place the bookmark in the
form field and protect the document, instead of the number going into the
text field, it pushes the text field to the right and inserts the number
into the plain table row. I'm going to be exporting this data at a later
date so I need it i...
|
5 |
03.01.2006 19:23:22 |
|
|
Help with automated "Procedure" template
Hello all! Im very new to VBA, and userforms in general, however Ive
managed to create a userform with a decent amount of VBA running behind
it.
My goal is to create a Policy/Procedure template for our company. The
userform launches on new document creation, and asks for various pieces
of info (Description, Orig. Department, Affected Department, Eff. Date
*this is validated*, To be approve...
|
2 |
28.12.2005 16:20:20 |
|
|
error with .range _
When going through the CreateAUserForm tutorial on Microsoft Word MVP FAQ Site
I get an error about the .Range _ field. The error says 'invalid use of
property' when it trys to compile.. Im not sure if this is because I am
running 2003? Any help appreciated?
Enter the following code between the Private Sub CommandButton1_Click() and
theEnd Sub
With ActiveDocument
.Bookma...
|
2 |
28.12.2005 12:00:20 |
|
|
Import Entire Excel Range
I'm trying to create a Macro that imports Excel sheets or ranges. I'd
like to have a listbox that contains all named ranges. Upon selection
of one or more ranges (I'm using I'd need additional controls in the
userform) , I need all ranges/sheets to to import in its entirety. I
can't seem to do this without skewing the formatting.
Ironically enough I work for a Tech training company. I'm tryin...
|
6 |
25.12.2005 09:46:11 |
|
|
Earn money Online - without risk!
Earn money Online - without risk!
For all people, who can utilize money.
Are you on the search for a lucrative source of income? Would you like to
work of at home out of, without
yourself you someone makes directions? Would you yourself like to
determine, when, how much and like often you
salary? Work for yourself ?
Then you should take yourself a couple minutes time. You happil...
|
1 |
25.12.2005 03:37:17 |
|
|
Controlling Word 2000 menus through VB6
Dear Experts,
I am doing a project in which I have to capture mouse clicks of a user on
different MS Word Menus.
Actually I am creating an Interactive MS Word CD tutorial. here are the
requirment:
1. We are planning to open a small hovering window on the user screen which
will have steps for the user to follow.
2. The user will open his own MS Word application from Start-> Pro...
|
2 |
25.12.2005 00:37:59 |
|
|
THE > SUPER-MONEY-SOURCE <
THE > SUPER-MONEY-SOURCE <
Would store / would copy this text or side before the administrator could
remove this letter.
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER-MONEY-SOURCE <
In this program, there is really money.
1200.- Euro ...
|
1 |
23.12.2005 01:21:39 |
|
|
THE > SUPER-MONEY-SOURCE <
THE > SUPER-MONEY-SOURCE <
Would store / would copy this text or side before the administrator could
remove this letter.
This special program is acquire copyrighting-protected, only with the
participation you the copyrighting at this program. Prohibited utilization
leads to the notice!
THE > SUPER-MONEY-SOURCE <
In this program, there is really money.
1200.- Euro ...
|
1 |
23.12.2005 01:21:29 |
|
|
FAQ - frequently asked questions - vba - please read before posting - unofficial December posting
FAQ = Frequently Asked Questions - brief - vba - unofficial
This FAQ is posted weekly.- more or less
Please save us all some time by reading it before posting to the
news group.
This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-...
|
4 |
21.12.2005 19:30:32 |
|
|
How to add userform in panel beside a document, like spell checker
Hi,
How to add the custom userForm in place of spell checker panel?
The spell Checker or ClipArt panel is displayed beside the document that
feature I want to add in my addin.
How is this possible?
Thanks,...
|
3 |
19.12.2005 18:05:57 |
|
|
Control Word userform from Access
Hi everyone
I need help sending a text string to a texbox in a Word userform. I can call
the Word macro to open the userform but I can't paste or send the result of
a string into the textbox even though the cursor is flashing in the box. How
do you access the objects in the userform assuming the userform name is
Userform1 and the textbox is Textbox1? Can it be done?
Thanks in advanc...
|
10 |
15.12.2005 12:18:03 |
|
|
Cancel Form and Hopelessly Lost Again
I have a UserForm with a Frame holding 1 textbox, an OK button and a Cancel
Button. The Cancel button is set with Cancel = True
I have a TextBox1_Exit Event as follows:
Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Not Cancel Then
If Not SizeValidator(TextBox1.Value) Then
With Me
.Frame1.Caption = Me.TextBox1.Text & " is invalid." _
& "...
|
14 |
15.12.2005 12:17:09 |
|
|
Replicate "X" Actions.
Is there anyway to make a control on a form replicate actions that are
triggered when a user clicks the "X" in the top right corner of the
form?
I am trying to solve a challenge where the contents of a textbox is
validated on exit whenever the user tabs to the next field or clicks on
other controls except one command button control labeled and set up as
a "Cancel" button.
Thanks to JGM ...
|
11 |
15.12.2005 02:15:54 |
|
|
UserForm in Word document.
...
|
2 |
14.12.2005 23:55:21 |
|
|
Make specified text uneditable in word (.dot)
All,
I have a requirement such that the specified portion of the text in a
word document (.dot) should not be editable by the user. Please
suggest.
Thanks
Srini
...
|
3 |
14.12.2005 18:18:44 |