| Thread | Last Post | Replies |
|
| Adding items to a combo box | 03 Dec 2006 20:16 GMT | 2 |
I've got a combo box on a form, and I'm trying to add items to it; however, the items are not showing up - I believe I'm missing a step. I've got the following in the code for the combo box right now: Private Sub cbWhatToProcess_Change()
|
| Select cell where column and row intersect. | 03 Dec 2006 20:01 GMT | 6 |
Hello everyone. I wish to be able to enter in a column header and a row label, and be taken to the cell where they intersect. Headers are in row 1, and row labels are in column A. I have used VBA a little, but I need to know which module to use. Can you help me on this? Thanks!
|
| Email worksheet from named list on another worksheet | 03 Dec 2006 19:51 GMT | 1 |
I have 60 worksheets. Each worksheet is a name of a person. I also have a worksheet named source; it has the name in column A and email address in column B. I would like to write a program to email each worksheet. It would read the name of the worksheet, lookup the name, get ...
|
| range as variable | 03 Dec 2006 19:31 GMT | 4 |
Range("C33").Select is there a way to may range a variable ? Sparky
|
| A little help vidth a Function | 03 Dec 2006 18:49 GMT | 2 |
I made this function and it works fine xDate is 1 cell vith a date, xRange is a range vith som difrent dates Function Vagt(xDate, xRange) Vagt = Application.WorksheetFunction.Match(Range(xDate), Range(xRange))
|
| printing single row only | 03 Dec 2006 18:40 GMT | 6 |
I have a form thta data is entered daily. Is there a way that I can print the form out. Then as data is entered, I insert the printed form in the printer and only print the new data on the form.
|
| macro help | 03 Dec 2006 18:22 GMT | 3 |
Hi, I have a macro that completes lots of stuff for me from a particular worksheet in another workbook. I want this part of my code....
|
| Automatic Formula Add | 03 Dec 2006 18:15 GMT | 4 |
I would like to have some formulas added to the end of a worksheet when the user enters a new row of data. How can I implement this? Example: Column A contains a date
|
| Offset Count if, between two words! | 03 Dec 2006 18:11 GMT | 2 |
Does anybody know how to do an offset countif, between two words in vba? I want to count the number of +1 or -1's, but, there can be varying amounts of +1's & -1's between these two Words.
|
| Can't start multiple instances of Excel with CreateObject | 03 Dec 2006 17:34 GMT | 3 |
In my ASP application (Classic not .NET), I instantiate Excel as follows: dim excelApp set excelApp = CreateObject("Excel.Application") When I call this ASP page simultaneously from multiple browsers, I only see
|
| Cursor row and column | 03 Dec 2006 16:35 GMT | 3 |
Is there any way to get colours to the row and to the column where the cursor is. They should change every time when moving the cursor. Thanks!
|
| "List Properties" not showing | 03 Dec 2006 16:06 GMT | 1 |
When I write in VBA I have been used to seeing the available commands which come next. This has stopped working - (i,e when I write ActiveSheet. and hold the curser by the "," I don't see available commands).I think this is the List Properties.
|
| copying modules and links | 03 Dec 2006 16:01 GMT | 3 |
I have a workbook that contains VB macros(Excel). I want to copy certain sheets from this workbook to another workbook and share it with others. However, when I do this and send it to them, the macro refers back to my original workbook.
|
| Can't get rid of clipboard questionwithout losing page. | 03 Dec 2006 15:57 GMT | 1 |
When I am starting to fill out a survey a window pops up that says"do you want to add this to your clipboard?"yes or no. I try no,nothing happens,alt&F4,nothing happens, and close and nothing happens.Only when I continue to push alt&F4do I get rid of it but the WHOLE window ...
|
| really stuck... | 03 Dec 2006 14:57 GMT | 3 |
I have a file on excel that contains many text entries of peoples names..... A10 has Ken in it A11 has Bill in it A12 has Alan in it etc etc etc....
|