List Box SOS

[Robin Bird]

Hi everyone, I am newer than a newbie at Excel programming. I can build
an awesome spreadsheet with lots of buttons and blinking lights but I
need help with some basic VBA code.

I have read and read and tried and tried again and I'm just not getting
it.

Here's what I have and need to do:

A User Form

Some Text Buttons

Some List Boxes

I need to first put the text from text box into a specified cell in a
worksheet. I have been able to accomplish that much but now I need to
disable that text box once the info has been added.


I also need to be able to add the items to the list box from an existing
list in a worsksheet. Does the list box have the capability to update
every time the list in the worksheet is edited?

Then I need to have the selected item from the list box inserted into a
cell in a worksheet and then be disabled.

Can the list box search so that when you type in the first few
characters it automatically goes to that listing?


Thanks again.

Mrs. Bears

 

[Bob Phillips]

You can disable the controls by setting the enabled property to false, but
it might help to give some visual feedback that it is disabled, such as

With Me.TextBox1
.Enabled = False
.BackColor = 12632256
End With

The best way to add items from a variable range is to use a dynamic formula.
Suppose your data is in A1:An, use this formula in the RowSource property
of the listbox
OFFSET(A1,,,COUNTA(A:A))

The ouput can be directed to a cell by setting the ControlSource property
to that cell, such as C1.

Last part, no, that is a combobox.


--

HTH

RP
(remove nothere from the email address if mailing direct)