Word Issues: Linking from Excel in VBA


C

Chuckie

I have been working on VBA assignment since last
Thursdays, and these are the difficulties I am having that
my 3 books and my online sources do not answer:

I have been able to link my comboboxes to a range of cell
in my worksheet. However, my code is not processing and
rembering the values that were clicked from the combobox;
especially since after clicking on userform, I will be
repeating this process with different values located on at
least 10 other userforms. So, can anyone tell me how to
having my code remember these values? I will need this
value for when I generate a Word document listing the
values.

3) End result: I need the values stored so I can generate
a word Report. I have written a code for this report
generation, and it does not work. Any suggestions?



Someone had suggested taht I go to: a VB .NET ng:
news://news.microsoft.com/microsoft.public.word.vba.general

However, due to where I am located, I do not have access
to this ng. Please help anyone?

Thank you for your time. =)
 
Ad

Advertisements

H

Henry

Chuckie,

When you unload a userform all the variables from that userform are lost.
I suggest you set up some Global variables in your module and use these for
storing variables that would otherwise be lost when you close your userform.

In Module - General
global ComBox1val As String
ComBox1Val =""

Before closing your form
ComBox1val = ComboBox1.Text

Do NOT Dim ComBox1val in your form

HTH
Henry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top