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!