#1
|
|||
|
|||
Textbox updating from combobox selection
This could very well be an easy solution. I am not familiar with using VBA/ComboBox/TextBoxes w/Word. Excel is more my forte, but I have a combox on a word document, with values a/b/c/d, i have two text boxes on the document which will update based on the selection. The values in the combobox are listed as a date and three letters, which the first textbox will use the date and second will use the three letters.
Example: Combobox has the following: 01/01/10 - ABC 02/01/10 - DEF 03/01/10 - GHI 04/01/10 - JKL Text box will use the date, text box two will use the letters. How do i code this? I have the values already done for the combobox, but having difficulty with the text boxes. Any help would be appreciated. Here is the combobox code: Code:
Private Sub ComboBox1_Change() Me.ComboBox1.List = Array("January 01, 2010 - ABC", "February 01, 2010 - DEF", "March 01, 2010 - GHI", "April 01, 2010 – JKL") End Sub |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Textbox Template | t0m46 | Word | 0 | 09-07-2010 03:38 AM |
How to use the content of a combobox for {IF} field? | Melaanie | Word | 0 | 06-14-2010 02:00 AM |
Creating Chart using VB textbox value | shyler82 | Word VBA | 0 | 03-12-2010 06:56 PM |
Array into ComboBox + Macro-Text into ActiveDocument | Vivi | Word VBA | 1 | 01-27-2010 07:03 AM |
Combobox manipulation | vsempoux | Word VBA | 3 | 10-31-2009 08:58 AM |