Programming

Listbox
Im sorry if this has appeared before but my server isnt showing it. Can I ask for some help for removing an item from a listbox? I wish to add a remove item button. the listbox is lb1 and the sheetname name it is rowsource to is checkout range a2:d15 Thanks in advance Greg ... 18 Jul 2008 11:20

Modify on close
I need to have the status of a workbook changed to modified even though a user has not made any changes. Is there a way to do this so when the user opens and views the file its status automatically changes? ... 21 Jul 2008 11:00

Ways to parse cells in mulitple selected locations
I'm trying to write a macro to parse multiple selected cells and copy records to another sheet. However, I can only make it work if these cells are in the same region. I would like to make it workable even if they are sperated by each others. I have attached my code here. I would like to attach the excel file he... 18 Jul 2008 00:03

Exit Excel (2003)
Is there a way for me to exit excel using a command button and vba code? I have a button and have coded it to exit the workwork book it's on, but I have been asked to code a button to exit Excel itself. Can anyone help me please. Thanks ... 18 Jul 2008 01:04

deleting named cells
I have the following code to delete named cells for a worksheet: With Sheets(nme & " DB") .Names(nme & "cst1").Delete .Names(nme & "cst2").Delete .Names(nme & "cst3").Delete .Names(nme & "cst4").Delete .Names(nme & "cst5").Delete .Names(nme & "date").Delete ... 18 Jul 2008 21:39

Listbox
Can I ask for some help for removing an item from a listbox? I wish to add a remove item button. the listbox is lb1 and the sheetname name it is rowsource to is checkout range a2:d15 Thanks in advance Greg ... 18 Jul 2008 01:04

Wrong current directory
I have an Excel Workbook that is saved in a directory. It contains a VBA macro with the following code: Dim StartDir As String StartDir = CurDir MsgBox (StartDir) .. . . However, it says that the current directory is another one, not the one in which the Workbook is saved. Why would it do ... 18 Jul 2008 17:33

Run time Error
I have a procedure the deletes a sheet and updates a listbox on a worksheet. I get the following error when this part of the code is ran "Sheets("Home").OLEObjects("ListBox1").ListFillRange = "wrkshtrng"" The error I get is this: run-time error '-2147352567 (80020009)': Could not set the listcursor property... 18 Jul 2008 21:39

=OFFSET(MATCH(My frustration continues!))
I have text/data in cells (A1:B10) B1 and B10 have the same data, with different corresponding entries in Column A. In C1 I have the formula =OFFSET(A1:B6,MATCH(Sheet1!B1,OFFSET(A1:B6,0,1,ROWS(A1:B6),1),0)-1,0,1,1) which gives me the data in A1, but.... what I want is to be able to look up the 2nd occ... 18 Jul 2008 04:08

Gridlines
Hi The following macro sets up my page to print with horizontal and vertical gridlines. Is there a way of only printing the Horizontal gridlines. Sheets("RDBMergeSheet").Select With ActiveSheet.PageSetup .Orientation = xlLandscape .Zoom = False .FitToPagesWide = 1 .FitToPagesTal... 17 Jul 2008 20:58