Re: Combo Box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Doug

Should the coding look like this? I am new to VBA so ned a few tips.

Also, would there be a way to enable the .List property to automatically be
assigned to all new combo boxes that are created?

Private Sub ComboBox1129_Click()
With ComboBox1129
..List = ComboBox1.List
End With
End Sub

Thanks again

"Doug Robbins - Word MVP" wrote:

Use VBA to set the .List property of the new combobox to the .List property
of the old combobox.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Owen" <Owen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6F757203-FCDE-40F3-A955-99AB2E6E5927@xxxxxxxxxxxxxxxx
Hi All...i was wondering if any gurus out there might be able to help with
the problem below?

I have a Word 2003 document which contains a table. I have recorded a
command
button Macro which enables the user to copy the last row of a table and
paste
it as a new row below.

The copied row contains a combobox list which has about 300 entries within
the combobox. When the macro creates a new row in the table, it copies the
shell of the combobox but does not copy the 300 entries. As a result, when
the new combobox list is clicked, there are no entries in the drop down.

Is it possible to include some coding to also copy the contents of the
combobox list?

Appreciate any help that can be provided.

Best Regards
Owen




.

Relevant Pages

  • Copying Combo Box Entries
    ... I have recorded a command ... button Macro which enables the user to copy the last row of a table and paste ... The copied row contains a combobox list which has about 300 entries within ... When the macro creates a new row in the table, ...
    (microsoft.public.word.docmanagement)
  • Combo Box
    ... Hi All...i was wondering if any gurus out there might be able to help with ... The copied row contains a combobox list which has about 300 entries within ... When the macro creates a new row in the table, ... Is it possible to include some coding to also copy the contents of the ...
    (microsoft.public.word.docmanagement)
  • Problem keeping return keystroke on default value setting
    ... Name: XXXXXX|Violation: XXX-XXXX ... the box that enables the enter key behaviour to "New Line in Field" but no ... three of those entries, but they aren't the real entries, but examples. ...
    (microsoft.public.access.reports)
  • Re: Problem keeping return keystroke on default value setting
    ... > That line wasn't exactly it, but it was a thick bar, almost like the text ... > the box that enables the enter key behaviour to "New Line in Field" but no ... > three of those entries, but they aren't the real entries, but examples. ...
    (microsoft.public.access.reports)
  • Re: Howto force APT to ignore deps
    ... Smart also has some coding (as I ... understand) that enables it to use standard Yast installation sources. ... > This was a broadcast from the netpolice. ... Prev by Date: ...
    (alt.os.linux.suse)