I have a userform with a text box and a listbox. As the user types into
the text box, I use the textbox_change event to see if the partial entry
(I use LIKE and a wildcard) has a match in the listbox, and if so I use
the listindex and topindex properties to select the match and ...

Hi I have never used a list box, with VBA before..
How do i do it when the list box can have several marked choices...
i want my macro to add text is certain cells, depending on what i
picked of the list in the list box.

So, I want Cell A1 to equal the value in lbl1.Caption. I tried:
Code
-------------------
   =lbl1.Captio

I have a simple HTML data dump which has special characters: áéíóúñ
In the HTML source I placed
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
When I download this table, all the accents are translated into unprintable

need to hide certain rows based on values entered elsewhere on the sheet -
please assist

I am looking to automate my daily Save As.  I create an updated workbook
every day that needs to be saved with a name and Date.  The name XYZ is the
same, but it is followed with a Date that is located in Cell B2 of sheet ABC.
Does anyone know if I can create a macro that will ...

I have an excel workbook which contains 3 worksheets - Order, Pending &
Complete - each sheet is exactly the same layout and header row
i would like to automate the following:
if on the Order sheet  "Complete" is entered in column H then move whole row

I would like to delete all rows from row 7 to the row number of the range
LastLine, which refers to a single cell. Any suggestions?

I am using the following macro to move data from one sheet to another,
call it from A to B.  The problem is that it doesn't just move the 500
rows of data from A, it also appears to move every blank row below the
data which lists as zeroes when the data is moved over to B. This

I am not good with macros, i would like to see few examples which can
generate e-mails from excel.
i have to send the status report to various persons
Please help

Hey folks,
Anyone know of a way to restrict data entry in a cell to one of onl
four total possibilities?  More specifically, is there a non-vb
solution to restricting users from inputting anything into a cell wit

Hey folks,
Anyone know of a way to restrict data entry in a cell to one of onl
four total possibilities?  More specifically, is there a non-vb
solution to restricting users from inputting anything into a cell wit

I am a VBA beginner and have managed to pull together an MS Access query
using the QueryTables feature.  However, each time I run my code, I get a
dialog box asking me to select the database.  I would like the code to
proceed without any user interaction once it's started.  How ...

There is a free download at the above named site that apparantly will
solve a vast number of memory  problems that occur.
HAS ANYBODY TRIED IT?
What do you think of it.

Hey folks,
Anyone know of a way to restrict data entry in a cell to one of onl
four total possibilities?  More specifically, is there a non-vb
solution to restricting users from inputting anything into a cell wit