Over 1 million tech questions and answers.

Word 2010 - Changing text based on dropdown box

Q: Word 2010 - Changing text based on dropdown box

I have what I hope to be a relatively simple question..

If I have a drop-down box in word, how can i get it to spit out a line of text depending on what I have selected in the list?

Read other answers
RELEVANCY SCORE 200
Preferred Solution: Word 2010 - Changing text based on dropdown box

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

RELEVANCY SCORE 91.6

Hello and thank you for taking the time to check this out.
I have checked various forums for an answer or modifiable answer to my questions, but I haven’t found anything that appears to suit my problems.

I am using MS Word 2010 (Windows8 64 bit) and VBA Controls from the ‘Legacy Form’ tool option, Dropdown Form Field.
The VBA code for PeriodicList is located in Module1, General, PeriodicList
The VBA code for Suburb is located in Module1, General, Suburb
I do not have Option Explicit at the beginning of the code module.

I am creating a form layout in a MS Word document (Macro enabled), for users to complete, print, sign then scan and email to us. I am not using the ‘Userform’ because it is too difficult to set out the way we want it to look.

I have tried various ways to re-gig things to try to get things to work …. But I am frustrated and unsuccessful after trying to source solutions from the net.

I am only relatively new to VBA and am slowly getting the gist of it … but it is a very slow process.

I have 2 questions:

Question 1:
Under PeriodicList()

When “Dropdown1” is clicked it shows the options available and when selected it will determine what is listed in “Dropdown2” – however, if the user goes back to clicking “Dropdown1” and makes a different selection, it doesn’t clear “Dropdown2” field, which can lead to confusion because the old content is still in the field.
How do I code it to clear “Dropdown2” if “Dropdown1” is clicked?

Question 2:... Read more

A:Cascading Dropdown lists using VBA in MS Word 2010 – 3rd dropdown list is not working

What existing "event" are you using to trigger the population of your combobox controls?

Are you able to post your sample document with the forms and code already attached?
Rollin
 

Read other 2 answers
RELEVANCY SCORE 82.4

Hi all,
I'm trying to create a form in Word that displays a table with fillable questions based on the results of a dropdown selection. So, for example, if I were asking how you get to work every day, the choices might be walk, bicycle, or drive.

If you choose walk, I have the following questions:
Distance: [text box]
Time required: [text box]

If you choose bike, I have the following questions:
Distance: [text box]
Time required: [text box]
Storage location: [text box]

If you choose drive, I have the following questions:
Distance: [text box]
Time required: [text box]
Parking location: [text box]
Monthly cost of parking: [text box]

I only want the relevant questions to show up for the option you select. I've tried this a couple of different ways, but I'm stuck. I can use a nested IF statement in the left column of the table and then use a text form field in the right column. If I do that, then the excess rows for the walk and bike options show a blank left column and a fillable form field in the right column, which is confusing.

I've tried using a nested IF statement for the whole table, but Word doesn't allow form fields within the IF statement (*shakes first at Word*).

I feel like my best option is to create a table for each option, and then show or hide the appropriate table based on the option selected using a macro. The problem is that I have no idea how to do that. I know that the preferred answer is not to do this in Word, however I'v... Read more

A:Show fillable table based on dropdown selection in MS Word

Read other 12 answers
RELEVANCY SCORE 73.2

I have created a document in MS Word 2010 that has a textbox with a background color. When I print the document to my printer (have tried multiple printers) or print to PDF, the textbox prints but the text itself does not print. (see attached image)

Upon further investigation of the PDF, I found that the text is actually layered below the textbox. For some reason, Word is printing the textbox on top of the text itself.

When I take the textbox, copy it to a new document, and try to print, it prints correctly.

I have also checked my printing preferences and I believe all the settings are correct.

Does anybody know how to fix this?
 

A:Solved: Word 2010 not printing text inside text box

Read other 13 answers
RELEVANCY SCORE 71.2

In word 2010, is there a way to have a Customized Ribbon Tab open on the ribbon when a new document is opened based on a template other than the Normal template?
 

Read other answers
RELEVANCY SCORE 70.8

I am using word 2010 and windows 10 on a Dell Inspiron 5559. I have reinstalled my printer and it's drivers and I have checked that the text colour is not white.
I am having problems with printing word documents. Within a word document any images print fine, as do the lines in a table but no text will print (in any colour).
I can see the text correctly in the word print preview panel.
Even the print test page prints with no text.

Can you help? Thanks
 

A:Word 2010 stopped printing text in word documents

what printer is this this ?
 

Read other 2 answers
RELEVANCY SCORE 70.8

Word 2003 Macro question:
I have 14 x 320 page word documents (School subject reports) created via
mail merges. At irregular intervals in each document there will be a page
which I wish to delete (the student does not do this subject). There is text
present from the mail merge template, however the is no data inserted into
this page. For example, on the pages I wish to delete the teacher name is
blank.
I have created a macro and attached it to a toolbar so that I can delete the
active page manually as I scroll through the document. However I would rather
have the macro search through the document, and where it finds the string
"Subject Teacher : " with no name next to it, then it can call the delete
page macro I made. However I cannot figure out how to make it search for that
string PLUS the missing teacher name (many different teacher names).
Can anybody help with this?
 

A:Deleting a Word page based on text search macro

I was offered the following solution on another forum. It works very well.
Thanks to Jean-Guy for this.
--------------------------------------------------------------------------------------
Try something like the following. You will need to find a way to determine
the exact string you need to search for when there are no teacher names
(strSearch).

'_______________________________________
Dim strSearch As String
Dim rgeStart As Range

Set rgeStart = Selection.Range

strSearch = "Subject Teacher :" & Chr(13)

With ActiveDocument.Range.Find
.Text = strSearch
Do While .Execute
With .Parent
.Select
With Selection
.Bookmarks("\Page").Range.Delete
.Characters(1).Delete
End With
End With
Loop
End With

rgeStart.Select

Application.Browser.Target = wdBrowsePage
 

Read other 1 answers
RELEVANCY SCORE 70.8

Hello,

I am hoping someone can help me here - I am trying to create a macro that prints Current Page based on specific text. I found script from 3 years ago (on this forum) that works nearly perfectly for us with only minor formatting adjustments. I'll post that below, but first want to explain the one change I am trying to make (you'll see I know little about Macros...)

The script below searches in text boxes, I need it to just search the document, not confined to text boxes. We have a series of letters that are generated automatically and then later sent to clients. These are generated in massive numbers, and we only print out the ones that come from our locations (7 in total). Right now we have to eyeball to see which ones we will print, but I know we can build a macro that will do it.

Here is the script I am basing working off of, which I called sort:

(The first part just sets margins to narrow, please ignore, it's the second part where I want to break away from the Text Box requirement and just look at the text within the document, and if it matches, print that page. I appreciate any help with this

Sub Sort()

With Selection.PageSetup
.LineNumbering.Active = False
.Orientation = wdOrientPortrait
.TopMargin = CentimetersToPoints(1.27)
.BottomMargin = CentimetersToPoints(1.27)
.LeftMargin = CentimetersToPoints(1.27)
.RightMargin = CentimetersToPoints(1.27)
.Gutter = CentimetersToPoints(0)
.HeaderDistance = CentimetersToPoints(1.25)
.FooterDistance ... Read more

Read other answers
RELEVANCY SCORE 70.8

Hello,

I am having an issue with word wrap in outlook 2007. I always want to send email as text at 76 word wrap. I tried several number of wraps 72, 74, 76 and 80 but all the same. below is my sample email with messed up word wrap.

> Yes, your email will still go through if the mail server doesn't
> support
> SPF. It only provides the extra benefit if the server does support it,
> but nothing bad happens if the server doesn't have SPF. You will still
> be
> able to send and receive email without a problem.

Is there any fixes for this?
Please help! Thanks!
 

A:Text Based Word Wrap in Outlook 2007 messed up

Read other 10 answers
RELEVANCY SCORE 68.4

Hello all,
I am fairly new to macros and am looking to split a large word document into smaller files based on a text string within the document, and then save those files as individual word documents, or as a bonus, PDF documents. The text string is "HEADER DATA".

Basically, I want the macro to find the text string "HEADER DATA", then select that page and all pages up to but not including the next instance of "HEADER DATA", then cut those pages from the original document, create a new document with the same formatting/ page layout, and save that document with a new file name. I want the process repeated until the end of the document, and each file saved with a new file name.

Some attributes about the file:

The text string "HEADER DATA" is always in the same location on a page, but is not at the top of the page.
The format and layout of the new document must match the current document.

Here is something I came up with (don't laugh too hard, lol). This will extract the first pages as intended, and saves the new file, but then Word stops responding. I don't quite know what the error is. Thank you in advance for any help.

_______________________________________________________________________________________
Sub SPLIT()
'
' SPLIT Macro
'
'
vPath = ActiveDocument.Path & "\"

Selection.Find.ClearFormatting
With Selection.Find
.Text = "HEADER DATA"
.Forward = True
.Wrap = wdFindContin... Read more

Read other answers
RELEVANCY SCORE 68

I'm still working on that event.

Here's a variation on the Judging category problem.

I have another report to run with two different categories: Equestrian and Other which now appear in the reports as 2 and 3 respectively. It would be much more useful to the people having to stage these entrants as "Eqtn" and "Othr" (space limitations)

I am wondering if I can use a variation on the expression I used to change the "0"s in the judging categories to "NOT Judged"

That expression was: IIf([judging category] = 0, "not judged", [judging category])

I am wondering if I used something like IIf([Class] = 2, "Eqtn", [Class] = 3, "Othr"])

Would this work?

Thanks,
Sara
 

A:Solved: Access 2010 New Changing number into two different Text.

Read other 16 answers
RELEVANCY SCORE 68

Hi All,

I am working on a special event that happens every year. I have the entrants for this event in a 2010 Access database table.
Some of the entrants are judged and some are not. Those that aren't judged get a "0" entered in there "judging category" field.

In previous years, my boss would take the information from the tables and dump them into Excel. She would then manually change the "0" into the text "Not Judged" and then make an Excel report to give to the judges.

She was so impressed with my other Access reports that she wants to skip the Excel dump and have me make an Access report for the judges, However, she still wants the non-judged entrants to show up on the reports we give the judges as "Not Judged". I have books that tell me how to write all kinds of numerical expressions, but none that tell me how to convert a number to a text message.

Please, if someone knows how to do this, let me know the steps, and if you do it in the query or in the report based on that query.

Thanks in advance,
 

A:Solved: 2010 Access help changing a number into text

Read other 14 answers
RELEVANCY SCORE 67.6

While working in Word 2003, my text is often corrected. The problem is the corrections made aren't necessary. What is causing this and what do I need to turn off?
 

A:Word keeps changing my text

I'm in linux, and can't do the procedure, but this should work.
 

Read other 2 answers
RELEVANCY SCORE 67.6

Can I sort of standardize text boxes for a specific document, i.e. whenever a new textbox is inserted it always has the same height and width and is always on the same position relative to the left margin of the document?

Markus

A:Word 2010 - Text Box

Yes. Format a text box as you like including postition then select the text box. Clicking one of the points/dots/little circles in the corner of the text box makes it easier to select it and not the text inside.

Once you have it selected click the text box icon in the ribbon and you should have the option "Save Selection to Text Box Gallery", fill out the details and now you have your text box template.

If you left the category as default (General) it'll show at the bottom below the built-in text boxes the next time you click the text box icon.

Read other 9 answers
RELEVANCY SCORE 67.6

I am creating a report that lists entrant cancellations for an annual event. The cancellations field is currently a Yes/No checkbox called "Cancelled". I would like the report I generate to actually say "CANCELLED" as opposed to "Yes" . Would the Expression for this be:

IIf([Cancelled] = Yes, "CANCELLED", [Cancelled])

or would it be different because the cancellation field is a Yes/No checkbox?

Thanks,

Sara
 

A:Solved: Access 2010 Changing Yes/No Check box to text in Report

Read other 10 answers
RELEVANCY SCORE 66.8

Dear All,

I have the following issue.

I have a text in microsoft word 2010 with this style :

i
want to
go
home

and i want it to be converted to seem like this
i want to go home

ie, multiple lines, to become one.

Any ideas?

Thank you in advance,
John

A:Word 2010 - Text Condensation

me too have this problem... basically when we are copying something form the pdf format to the word one... i use to do it manually ... if some body can help it will be great

Read other 5 answers
RELEVANCY SCORE 66.8

I am trying to find a way to do vertical text in Word 2010 and cannot find anything that explains how to accomplish this. I need an option to have the text type out like this:

T
h
i
s

t
e
x
t

i
s

v
e
r
t
i
c
a
l

Any help you can give me would be great. Thank you!

A:Vertical Text in Word 2010

In order to do that in MS Word you must use a Text box. If you're using Office 2007, insert text box-->Enter your text-->Select the box-->format-->Text Direction.

Read other 4 answers
RELEVANCY SCORE 66.8

Hi,
When i insert/paste images into a word 2010 document it also seems to be pasted with the "In Line with text" wrapping. However i dont want that. I want my images to pasted in "Tight"

I have gone into Option > Advance, and changed my paste setting and saved it, however when ever i start a new document it still apears as "In line with text" but when i go into option it says default is "Tight" but the document doesnt seem to do it.

How can i fix this??

A:Text wrapping in Word 2010

Here is a reg file to force those settings.

Save the .reg file to your desktop.
Double click/tap on the downloaded .reg file to merge it.
When prompted, click/tap on Run, Yes (UAC-Windows 7/8), Yes, and OK to approve merging the .reg file.
You can now delete the downloaded .reg file if you like.

Read other 6 answers
RELEVANCY SCORE 66.4

(We use Word 2003 SP2. All files live on a shared server that we access through our WinXP laptops and company network.)

To facilitate speedy document creation we created a template called Lab_Modules.dot. At the top-right corner of that template's header is the italicized place-holder text Exercise Name, which we manually change to match the title of each document we create with that template. We have created dozens of two-to-five-page files with this template, and on each page of every file we have carefully replaced the dummy header text Exercise Name with that file's actual title.

After we Insert as Link several of these files to create our finished lab document, we notice that the headers in a few (but never all) of the sub-documents we inserted as link have lost their title name and that the dummy text Exercise Name has mysteriously returned. Because we have dozens of these short sub-files, and we typically string together ten to fifteen of them (using Insert as Link) to create our library of finished lab documents, we are puzzled by the seeming randomness of this behavior - it does not appear to be restricted to a select few sub-files. Can you tell us how/why our dummy header text is returning and how we might fix the problem?

Thank you for your valuable time,
Curtis
 

A:Word header text mysteriously changing

I am not quite sure why it would be happening.. Have you tried making a master document with subdocuments instead? You can create or link to subdocuments in the "Outline" view using the "Insert Subdocument" button. Try that out and see if it is still having a bug.
 

Read other 3 answers
RELEVANCY SCORE 66.4

A work friend has just told me she has a 34 page document and needs to change the text in the headers in three different "chunks" throughout the document. So, eg., the first 10 pages would read differently to the next 10 pages etc. in terms of what is typed into the headers.

We tried using section breaks and clicking Same as Previous on the H/F floating toolbar but it did not help.

Help would be appreciated.

Thank you - Julie
 

A:Word 97 changing text in subsequent headers

Read other 8 answers
RELEVANCY SCORE 66

I'm "scundered" to only now discover a whole raft of text effects are available within Word 2010 except I can't access them!! That's partly the reason I'm only now realising they exist, as the button's been greyed out and I've continually missed spotting it to investigate until I read about them online and twigged.

Anyone any ideas on how I can get them to show again? I've gone through the options and checked they're all in the menu ok and even tried to set up a new group and put them in there, but same problem. The button shows but as unavailable. I've no issues with any other buttons in the program being like this but given the bulk of my Word usage is text editing, I'm SO upset to have not spotted this a LONG time ago, as no doubt the beta will soon be closing and I've no means to afford the full pkg. So ideally I'd like to be able to utilise the functions and set text into documents that at least then I'll have for future use.

A:Can't access text effects in Word 2010

I could be wrong but I don't remember that feature being enabled in Beta

Read other 2 answers
RELEVANCY SCORE 65.6

I'm hoping someone has some insight into this, as my web searches are coming up empty. I am trying to create a template in Word 2010 that will consist of a series of text boxes that can be filled in. I have set up the typical size of each text box and aligned them. I have also set the properties (shape properties) of each text box so that it will grow if the text entered is larger than the size I have set up. In Format properties position, I have unchecked Allow Overlap, hoping that as a text box grows, the boxes under it would move down the page. Once, this actually happened but I have not had consistent luck with it. I have experimented with all the options, including move with text, etc. but nothing works. I would appreciate any help with this issue.
 

A:Prevent Overlapping between text boxes in Word 2010

Read other 8 answers
RELEVANCY SCORE 65.6

I often use MS Word 2010's "speak selected text" feature to help edit portions of the text I write. The highlighted text plays back fine, but sometimes it just stops after a few hundred words, even though I've highlighted more text. Is there a limitation to the amount of text that can be played back at a time? Is that why playback just stops? Thanks.

A:Word 2010 speak selected text limit?

The limit is 4096 characters, including spaces. Note that paragraph and page breaks are counted as one character included in max amount of characters. Limit is the same in Word 2010, 2013 and 2016

In English text that translates to roughly 700 to 800 words, about 1? to 1? pages (default Calibri 11pt font).

Kari

Read other 0 answers
RELEVANCY SCORE 65.6

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Enterprise, Service Pack 1, 64 bit
Processor: Intel(R) Core(TM) i5 CPU U 520 @ 1.07GHz, Intel64 Family 6 Model 37 Stepping 5
Processor Count: 4
RAM: 3891 Mb
Graphics Card: Intel(R) HD Graphics, 1721 Mb
Hard Drives: C: Total - 305142 MB, Free - 243716 MB;
Motherboard: LENOVO, 2985F8G
Antivirus: ESET NOD32 Antivirus 4.2, Updated and Enabled

Hi,

I hope you can help me.

I am trying to find a VBA code to identify text by its RGB colour, and then delete it from the document. With this in mind, I am currently trying to edit a code I found online which changes text from black RGB (0,0,0) to red RGB (255,0,0). I thought I could use the same concept but to just delete the black text instead of changing it’s colour.

I am a beginner and it is just not that simple for me. Does anyone have any suggestions?

Thanks in advance!

Brigitte
 

A:VBA and Word 2010: Trying to identify text by RGB colour and delete it.

Hi

You can do this using the in-built Find/Replace in Word.

click on Replace
click on "Format" (at the bottom of the replace screen)
Click on "Font"
Click on "Font Colors"
Click on "Custom"
Change the RGB settings to 0,0,0
Click on OK twice
Click in the "Replace" box
Click "Replace All"

You can record all of these steps in a Macro
Code:
Sub Macro1()
'
' Macro1 Macro
'
'
Selection.Find.ClearFormatting
Selection.Find.Font.Color = wdColorBlack
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = ""
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub

Try either of these on a copy of your document in case something goes horribly wrong.
 

Read other 1 answers
RELEVANCY SCORE 65.6

In word 2010, I have a table of contents page and I justified the text to give it a clean look so that chapter headings are in line as well as the page numbers. When I print the page my printer does not print the justified text. Is this caused by my printer or is it in word? and how can i fix it?

A:printer does not full justify text from word 2010

Dont know whats up, check the "print preview" this is how the document should come out the printer.

Read other 2 answers
RELEVANCY SCORE 64.8

I'm trying to create a macro in Word 2010 that will allow me to insert text from file but pauses when it takes me to the specific folder so that I can select which file to insert. I have a folder containing over 50 files from which I want to choose.

I created this macro once from directions I found on line but my macros were recently lost and I'm having to start all over. I can't for the life of me remember the code for the macro and I can't even remember what question I asked to get to the code previously!
 

A:Solved: Word 2010 Macro Insert Text from File

Read other 12 answers
RELEVANCY SCORE 64.8

I have an assignment in which I have to make a certain affect in Word. I've been looking around and i can't find it. Im not sure if its called a "text affect" but what ever it is, i need to replicate it exactly. I took the picture of it straight from my teachers word document. Anyone know how to make it?
Thanks.
textaffect.PNG

A:How do I make this Text Affect in Word 2010? (Picture included)

Shouldn't be telling you this as it's an assignment but you seem to have done the research .... it's "insert" "word Art" "wordart style 1"

Read other 3 answers
RELEVANCY SCORE 64.8

Is there a way to dictate, in Microsoft Word 2010, that any newly-created document will have my own Style in place as the default one, or whatever the term might be, if anything, that decides what the starting set-up is? It's currently the font Calibri, size 11, 10.5 Multiple line spacing, 1" margins on all sides, etc. My preferences are different in every way, so I manually change all of that every time I make a new document.

A:Changing the default Style in Microsoft Word 2010?

Have you tried changing the normal template? I was able to find directions on how to find that for 2003 here, but it's the same process for 2007 and I would imagine 2010. I don't have 2010 on this computer to double check.

Read other 1 answers
RELEVANCY SCORE 64.8

Hi,

Is it possible to change Microsoft Word spellcheck from US English to British English? Can some help me out on this. Thanx
 

A:Changing Word 2010 spell check settings

I was going to originally copy and paste one of the replies found HERE, but a few of them contain some information you might be interested in to know about.
 

Read other 1 answers
RELEVANCY SCORE 64

I am trying to create an AutoOpen VBA Macro in Word 2010 files for automatically inserting the same dates into 2 different text boxes when I first open the file. Ideally, I would want 1 file to do this always for Yesterday's date (whatever that may be) and another file to do this for Friday's date (whatever that may be).

Reason for this is because our mail room gets mail the day before I get it on my desk and I need to date stamp it using a Word 2010 template where I have 2 text boxes (please see attached file--oh, doesn't seem like I can attach the file???) for Tuesday through Friday. Right now, I am using the Macros I have created (1 for Yesterday's Date and another Macro for Friday's Date which is Date() -3).

I want to use that Macro logic to put that into the Text boxes I have when it first opens? Please help me with this anyone......

It doesn't seem like I can attach the file so here is the VBA code:

Sub AutoOpen()
'
' AutoOpen Macro that places the cursor at the last position of edit (not default of top left) (will work with Protected View)
If Application.ActiveProtectedViewWindow Is Nothing Then
Application.GoBack
End If

' InsertTextBox1 Macro
Dim Shp As Shape
Set Shp = ActiveDocument.Shapes.AddTextbox( _
Orientation:=msoTextOrientationVertical, _
Left:=22, Top:=252, Width:=25, Height:=170)
Shp.TextFrame.TextRange.Text = "NMM RECEIVED: "
Set Shp = Nothing
Selection.InsertAfter Format(Now() - 1, "dddd, ... Read more

A:Word 2010 VBA AutoOpen Macro to Insert Dates Into Text Boxes

Read other 16 answers
RELEVANCY SCORE 64

Hi all,

I'm looking for a way in either Excel or Word 2010 to add text to a line before the text. So, for example I have something like this:

Name1
Name2
Name2
etc..

And then I want to add "1 " before each line in a way that is copy pastable, so it looks like so:

1 Name1
1 Name2
1 Name3
etc..

Is there anyway to do this. it's mostly just to help with copying text from Word/Excel documents onto forums so it formats correctly. Any help at all is much appreciated

Cheers,
Matt
 

A:Solved: Word/Excel 2010 Adding text before each line in a Document

Hi Matt,
It's probably a little cleaner to do it in Excel than in Word, but also a few extra steps. In Word:

You can run a find a replace. Without including the quotes, find "^p" (the paragraph symbol) and replace with "^p1 " (there's a space after the 1). This replaces the paragraph break at the end of each line with another paragraph break and then "1 " at the beginning of the next line. The problem with this method is that the first line won't have a 1 in front of it (because there's no paragraph break before that line) and the last line will have a stray 1 after it. But this should be relatively minor cleanup.

Alternatively, in Excel:

Insert a column to the left of your names. Without including the quotes, enter "1" in the first cell and copy it down your spreadsheet. Insert a column to the right of your names and enter this formula (assuming your names are now in column B):

=A1&" "&B1

This should give you the result you're looking for in column C. Hope that helps.
 

Read other 3 answers
RELEVANCY SCORE 64

I am trying to create an AutoOpen VBA Macro in Word 2010 files for automatically inserting the same dates into 2 different text boxes when I first open the file. Ideally, I would want 1 file to do this always for Yesterday's date (whatever that may be) and another file to do this for Friday's date (whatever that may be).

Reason for this is because our mail room gets mail the day before I get it on my desk and I need to date stamp it using a Word 2010 template where I have 2 text boxes (please see attached file--oh, doesn't seem like I can attach the file???) for Tuesday through Friday. Right now, I am using the Macros I have created (1 for Yesterday's Date and another Macro for Friday's Date which is Date() -3).

I want to use that Macro logic to put that into the Text boxes I have when it first opens? Please help me with this anyone......

It doesn't seem like I can attach the file so here is the VBA code:

Sub AutoOpen()
'
' AutoOpen Macro that places the cursor at the last position of edit (not default of top left) (will work with Protected View)
If Application.ActiveProtectedViewWindow Is Nothing Then
Application.GoBack
End If

' InsertTextBox1 Macro
Dim Shp As Shape
Set Shp = ActiveDocument.Shapes.AddTextbox( _
Orientation:=msoTextOrientationVertical, _
Left:=22, Top:=252, Width:=25, Height:=170)
Shp.TextFrame.TextRange.Text = "NMM RECEIVED: "
Set Shp = Nothing
Selection.InsertAfter Format(Now() - 1, "dddd, ... Read more

Read other answers
RELEVANCY SCORE 63.6

How do I hide and show different columns based on values selected from a drop-down list? I wrote a code to do this but there has to be an easier way.

Cell C2 has a drop-down list. This list is from another part of the workbook. Next to the list in the workbook, I put values representing the beginning of the columns I want to Show.

Units 4
Intervals 5
Time 6
All 0

On the page that I am working with I have created a spreadsheet that tracks monthly amounts of Units, Intervals and Time (in separate columns). I want to be able to select "Units" from C2 and show columns, 4, 7, 10, 13... +3 each) then be able to show Intervals (and only show columns 5, 8, 11, 14... etc), then Time (and show columns 6, 9, 12, 15... etc) and if I select All, I want to show everything.

Dim x As Integer
Dim vCriteria
vCriteria = Range("C4")

If vCriteria = "0" Then
Columns("D:AS").Select
Selection.EntireColumn.Hidden = False

Else
Columns(vCriteria).Select
Selection.EntireColumn.Hidden = False

Columns(vCriteria + 3).Select
Selection.EntireColumn.Hidden = False
Columns(vCriteria + 6).Select
Selection.EntireColumn.Hidden = False
Columns(vCriteria + 9).Select
Selection.EntireColumn.Hidden = False
'... and repeat til vCriteria + 40 (column AS)

End If
End Sub

This works. But....
There has to be an easier way to write this code. Additionally, I want to be able to add more more columns to this spreadsheet as it is tracking monthly numbers so I don't wa... Read more

A:Excel VBA: Show/Hide rows based on dropdown value

Read other 8 answers
RELEVANCY SCORE 63.2

Greetings,

I need a step by step list to make the font sizes of my return address envelopes bigger by about two levels. I am happy with the font size of the delivery address default, but the return address default is too small. The guide I found on line wasn't very helpful, as it read like brain surgery!

I have legacy Word experience using Word 97-2003, and envelope settings were much easier to select on those versions! Note that I want to keep the return address envelope font size as the default envelope setting.

Jack
 

Read other answers
RELEVANCY SCORE 61.2

I have a list of all my MP3's in a text file. I want to delete everything on the line except for Artist - Song Name.mp3.

For example:
Green Day - Armatage Shanks.mp3 ::INFO:: 2.68Mb 2m17s 160/44.10/JS

I want to delete everything starting at ::INFO::
 

A:Need a text editor/program that can delete part of a line of text based on a string

I figured it out. I had to learn about regular expressions in text editors.
 

Read other 1 answers
RELEVANCY SCORE 60.8

Text box border macro based on if text box contains data
Hi i have been trying to create some worksheet code so that for a particular sheet if a textbox is blank the border does not show, but if this contains data the border does show. I have the below code, this works if the textbox contains no data but has a border, the code removes the border. However if the text box contains data but has no border the code doesnt draw the border. I am very new to vb so any help gratefully received.

code is:

Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)

Sheets("LRCR by division-open").Select

Shapes("Text Box 1").Select

If TextBox1 = "" Then

Selection.ShapeRange.Fill.Visible = msoTrue

Selection.ShapeRange.Fill.Solid

Selection.ShapeRange.Fill.ForeColor.SchemeColor = 65

Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoFalse

Else

Selection.ShapeRange.Fill.Visible = msoFalse

Selection.ShapeRange.Fill.Solid

Selection.ShapeRange.Fill.Transparency = 0#

Selection.ShapeRange.Line.Weight = 0.75

Selection.ShapeRange.Line.DashStyle = msoLineSolid

Selection.ShapeRange.Line.Style = msoLineSingle

Selection.ShapeRange.Line.Transparency = 0#

Selection.ShapeRange.Line.Visible = msoTrue

Selection.ShapeRange.Line.ForeColor... Read more

A:Solved: Text box border macro based on if text box contains data

Read other 13 answers
RELEVANCY SCORE 60.4

I am having difficulty with text diplaying in bizarre fashion. The machine is a Dell Optiplex tower operating Windows XP Pro. When I am in an application or browsing web pages and choose one of the dropdown boxes, the box drops down and shows the outside lines of the box. Then when you swipe your cursor over the dropdown it will display the text that is invisible. All that I have to do to show the text is pass the cursor over the area. If I do not swipe the are with the cursor the text will be there, I assume, but never display.
Has anyone encountered this issue before. Thank you in advance.
 

A:Dropdown text will not display

rmoon73 said:

I am having difficulty with text diplaying in bizarre fashion. The machine is a Dell Optiplex tower operating Windows XP Pro. When I am in an application or browsing web pages and choose one of the dropdown boxes, the box drops down and shows the outside lines of the box. Then when you swipe your cursor over the dropdown it will display the text that is invisible. All that I have to do to show the text is pass the cursor over the area. If I do not swipe the are with the cursor the text will be there, I assume, but never display.
Has anyone encountered this issue before. Thank you in advance.Click to expand...

Is this for a certain web page, or all web pages?
 

Read other 2 answers
RELEVANCY SCORE 60

Anyone know if there is a way to alter the formating (font, color, etc.) of the text in a Forms dropdown box? I know how to make them, feeding from a list of choices in other cells. But, they come out with such boring font type and size.
 

A:Excel dropdown text formating

Read other 6 answers
RELEVANCY SCORE 58.8

I have many word documents with similar bookmarks. Some with more, some with less. I need to check the documents to see if certain bookmarks exist and if so, change the Bookmark name and text.
 

A:Solved: Word 2010 - Check if Bookmark is present and if so, change text and Bookmark

I don't know if this solution is the best way but I did figure out a way to do what I want.
If ActiveDocument.Bookmarks.Exists("Old_Bkmrk") = True Then
Selection.GoTo What:=wdGoToBookmark, Name:="Old_Bkmrk"
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.InsertAfter "New_Text"
ActiveDocument.Bookmarks.Add Range:=Selection.Range, Name:="New_Bkmrk"
End If
 

Read other 1 answers
RELEVANCY SCORE 58.8

Greetings! I've searched everywhere for the answer to this issue. It must be common, but I can't find it anywhere. I'm using MS Word 2007, but the problem was the same in 2003. I sometimes get a text box that is behind regular text. I need to move it. One normally just selects a text box and drags, or cut and paste, it where one wants. However, when it is behind text, it can't be selected. I have found no way to select normal text and "send it behind."

How do I get to this text box that is behind my regular text? I've been told to "move the regular text out of the way, then you will be able to get to your text box." But the text box moves with text!

Thanks,

7nyerik
 

A:Text box stuck behind regular text in MS Word 2003 and 2007, Can't select text box.

You can't post a link to your computer to post an image. We cannot access your computer. Upload the png image as an attachment please. To do that, scroll down to "Manage Attachments" then click on "Browse" to locate the file on your computer then "open" it and then click on "Upload" and submit your reply.
 

Read other 1 answers
RELEVANCY SCORE 58.4

Cell K6 is a dropdown menu with Incomplete & Completed as choices and if Incomplete is selected, Cell J6 is highlighted red, If completed is selected, J6 is highlighted Green.

Excel 2010
 

A:Dropdown Menu text selected, highlights other cell

Use conditional formatting and add two rules

for 2007, 2010 or 2013 excel version
Conditional Formatting

Highlight applicable range >>

J6
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=K6 = "Incomplete"
Format? [Number, Font, Border, Fill] > choose fill RED
choose the format you would like to apply when the condition is true
OK >> OK

Then repeat above with a new rule
=K6 = "complete"
and use fill Green
 

Read other 1 answers
RELEVANCY SCORE 57.6

Behaviour of a dropdown changes in case we are changing the screen resolution. In case we are having lot of items, place of launch of dropdown list is getting changes as soon as we are changing the resolution.

this seems to be a bug.

A:Change in behaviour of dropdown on changing screen resolution

Sorry not sure what you are trying to explain, please elaborate.

Read other 2 answers
RELEVANCY SCORE 57.6

Hi All,

I'm building a workbook with two sheets - one has data, the other a form. Essentially I am adding a specific customer to a row via a dropdown box (which I have already completed) and now I want to populate the corresponding cells with their info (account number, address, city, etc) automatically.

Like I said, I already figured out the dropdown box, but it escapes me on how to automatically populate the remaining cells.

Any advice?
 

Read other answers
RELEVANCY SCORE 57.6

Hi Guys,
could someone give me or point me to a step by step procedure for creating a self poplating drop down box in Access 2010 and printing the report. I am trying to teach myself - have so far created a db and a number of tables. One of the tables is for States and is populated accordingly. I am trying to make up a data base for say -attendance at theatres and then printing out a report on Theatres attended, dates, location and movies watched. (I am not doing this for any commercial organistion).
Any help would be appreciated, thanks.
 

A:Solved: Creating a self populating dropdown box in Access 2010

I requested that your post be moved to the Business Application thread. You will probably get more/better answers there.
 

Read other 1 answers
RELEVANCY SCORE 57.6

I created a drop down list into a word document within a table. But I wanted that table in another document, when I copied that table to another doc, the dropdown did not work. Does anyone know how to make this work?
 

A:Word Dropdown

what about including that whole page with the table in your document
 

Read other 1 answers
RELEVANCY SCORE 56.8

Hi guys,

Could someone please give me a hand with a little project I'm working on.
This is a little complicated, I hope you understand what I am trying to say

In MS WORD, I am currently able to make drop down forms.

Is it possible that if I were to have multiple drop down forms; I could use the first form menu to define what is listed in the other form menu's.

E.g. [Drop-down form 1] has 3 catogorys in its lists;
- Menu 1
- Menu 2
- Menu 3

When Menu 1 is selected from [Drop-down form 1], [Drop-down form 2] menu changes to whatever list I pre-define for menu 1. However if Menu 2 were seleceted, then [Drop-down form 2] will display Menu 2's list accordingly. Etc

Is this possible? I've seen it used many times before on website forms, but can I do the same in word?

If the above is possible... to take things one step further.. Can I do the same with the 2nd drop-down form; (any option that I select from it) to predefine choices for for a 3rd drop down menu?

Sorry if this is confusing, if there is any part you want me to clarify I'll be happy to do so.

Thanks for your help in advance.
 

A:Help with MS Word DROPDOWN forms

Read other 9 answers