List Box SOS
 

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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

List Box SOS
 

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)


"Robin Bird" wrote in message
...


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



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!