| Thread | Last Post | Replies |
|
| Populate ListBox with Filtered Records | 28 Apr 2007 03:12 GMT | 2 |
Using Excel 2003. I have a database worksheet named Projects, with three columns of information: Id, Name, and Location. The worksheet currently has over 200 records.
|
| .Xla Password forgot....! | 28 Apr 2007 03:06 GMT | 1 |
I have forgot my .xla password. Could some one talented from the group retrieve it...? Thanks, Thyag
|
| Automatically create new sheets... | 28 Apr 2007 03:04 GMT | 1 |
I have a spreadsheet with Data that looks like the following... A B C 1 Sheet 1 Description1 Unit of Measure 1 2 Sheet 2 Description2 Unit of Measure 2
|
| Sorting chart by name | 28 Apr 2007 02:42 GMT | 5 |
I have some 15 charts in a spreadsheet along with some data. I want to reposition the charts in 3 rows and 5 col. I achieved this but the issue, position of the charts get exchanged once i run the macro. For example, after "Chart 4" is repositioned, macro selects
|
| Protecting whole workbook | 28 Apr 2007 02:14 GMT | 5 |
Hi, I have a workbook with approx 30 worksheets and have protected each worksheet with the following macro's Private Sub Protect_Workbook_Click()
|
| Regex techniques | 28 Apr 2007 00:17 GMT | 5 |
I am still struggling with the use of the RegExp object in the VBScript_55 library, in Excel/VBA. In my "old" regex processor, BKReplacem, I could use special characters such as \n in the REPLACEMENT string, not just the search string. But that does
|
| Problem managing Enter Key behavior in a userform | 28 Apr 2007 00:11 GMT | 1 |
I have a userfrom that contains three combo box lists and 8 text boxes. My user uses the comboboxes to select from lists of values. They then enter data in to the text boxes. Finally they select a save command button to save all the data to a row in a
|
| Using Do Loops to copy data | 27 Apr 2007 23:52 GMT | 7 |
I need a bit of code that will search through each cell in a column and look for “Agent Name:” then choose cell to its right and create a new sheet with the value of the selected cell as the name. Below I have added what I tried, which obviously did not work. Any help on
|
| Macro to find a word and copy all rows with this word to diff ws | 27 Apr 2007 23:16 GMT | 3 |
I'm trying to create a macro to run a search based on info put into an input box and copy all of the rows from column A to column M containing this info and paste to a specific worksheet. The worksheet that the info will be found in will always be the same format,
|
| Calendar Control - Years | 27 Apr 2007 23:01 GMT | 6 |
Hi I've used the tutorial at www.fontstuff.com/vba/vbatut07.htm to set up a calendar for date selection in a cell. I've used an earlier posting (12/5/2006 6:28 AM Calendar Control) by Tom Ogilvy to pick up the Friday of the week for any date selected.
|
| Referring to two different open worksheets in code | 27 Apr 2007 22:42 GMT | 8 |
I'm in a bit of a quandry and I'm sure someone here can help me out. I have the following snippet of code: With Application.FileDialog(msoFileDialogFilePicker) .AllowMultiSelect = False
|
| Fun with SubTotals | 27 Apr 2007 22:40 GMT | 3 |
I am trying to run a subTotal function on two columns of data. Column 2 has our Techs names and Column 3 has status info. First I subtotal the Techs and then the status. Everything works well in Excel 2007.
|
| Left Right Mid | 27 Apr 2007 22:34 GMT | 6 |
I have data in cell A1 that looks like this. I want to be able to seperate it with the left right mid functions into B1,C1, D1, E1, F1, and get rid of the comma's. Any help would be greatly appreciated. 25632, 27865, 456456, 987456, 789456
|
| clearcontents problem | 27 Apr 2007 22:32 GMT | 4 |
I am using a commandbutton_click sub on a specific worksheet to automate some reset features on a timesheet I've built. I want to be able to clear and reset values on other worksheets in the same workbook at the same time. Inside the commandbutton1_click sub on "Sheet1" I use ...
|
| Presetting options when opening Excel | 27 Apr 2007 22:28 GMT | 3 |
I want to open Excel and run a program that has some sensitive material. I do not want the user to do anything without using buttons that I have developed. I would like to make sure that all the toolbars are removed and most of the menu items bars are not useable. I have to do ...
|