Search results for query: *

Thanks much for your suggestion. I have it working now!

I have a UserForm named "TotYrReturnsForm" with a CommandButton named "CloseButton" The form is run in a Sub named "Enter_5Yr_Averages" Within the Sub "Enter_5Yr_Averages", I have the following line code: TotYrReturnsForm.Show vbModeless This line code opens the "TotYrReturnsForm" UserForm...

Thank you for the suggestion. Yes, I have been doing some pretty sloppy fixes myself:). Specifically, iteratively playing with the number of spaces between the columns and manually moving column headings above the ListBox. Thanks again!

Thank you but I am not trying to format a number. I am trying to format Text. Specifically, I currently have the "TextAlign" "Properties" for the ListBox set to "2-fmTextAlignCenter". I am trying to get one column in the ListBox left-aligned (i.e. effectively set to "1-fmTextAlignLeft") while...

I have used the "FormatNumber" VBA function to format Column 1 in a ListBox for numbers with four decimal points: Area(1, j) = FormatNumber(Range(“A1”), 4) If I wanted a different format for column 2 (e.g. six decimal points) this can easily be done with: Area(2, j) = FormatNumber(Range(“A1”)...

Thanks again Skip. You are a great help!! Jim

I have several worksheets with matrices that I am trying to reference by using a summary worksheet. For example, I know I can do the following: =INDIRECT($L$24&"!B10"); where L24 contains the worksheet name and this references Cell B10 for the Worksheet named in Cell L24. What I am trying to...

Thanks much Skip!! Jim

I created a Pivot Table with multiple selections from a Report Filter. My question is once I make a selection is there any way to name the selection so I can retrieve the same selections from the Report Filter without having to remember and make the same selections each time? Any help would be...

I see. I assume that the second sRng(0) is meant to be sRng(1). Instead of setting the PrintArea, the VBA code prints each area one at a time. Correct? Yes, this works fine. Thank you again.

I have a worksheet with several continuous areas that I would like to print on separate pages. For example, two adjacent print areas are as follows: CR6:CU77, CV26:DM77 When I use VBA to enter the above into Page Layout/PrintArea, Excel combines the PrintArea to CR6:DM77. Is there a way I can...

Thank you. Unfortunately, I am setting the PageArea with VBA code so setting the Page Breaks manually is a problem. Thanks again for your help.

I have a worksheet with several continuous areas that I would like to print on separate pages. For example, two adjacent print areas are as follows: CR6:CU77, CV26:DM77 When I enter the above into Page Layout/PrintArea, Excel combines the PrintArea to CR6:DM77. Is there a way I can stop Excel...

I am trying to convert a 2002 Access Program to 2007. When I try to Save the open Database as Access 2007, I get the following message: you attempted to open a database that is already opened exclusively by user 'admin'. Any suggestions as to how I can convert or save the current database to...

Hi Jake, I was beginning to think that I was all alone. I am not sure it will solve your problem, but by trial and error I did find what was causing my problem. I generally turn off "screen updating" in all my macros to speed things up a little and avoid vertigo by watching worksheets bounce...

I just converted to Excel 2007. The below code in a Visual Basic Module worked fine for Excel 2003, but now it PrintPreviews the worksheets but does not let me actually print or even close PrintPreview. I can scroll through the PrintPreview pages but everything else is frozen. I can only get out...

Thank you. Sorry for my confusion.

I just converted to Excel 2007. The below code in a Visual Basic Module worked fine for Excel 2003, but now it PrintPreviews the worksheets but does not let me actually print or even close PrintPreview. I can scroll through the PrintPreview pages but everything else is frozen. I can only get out...

PHV, Yes, that solved both of my problems (visibility and preventing a User from interrupting the program). Thank you. Jim

I am using VBA to export Access data to an Excel Workbook. The VBA code includes the following: Ans = MsgBox("Existing Data in " & xWkBkName & " will be replaced. Continue?", vbYesNo, "Data Replacement Warning") If Ans = vbNo Then Exit Sub When the program runs, the MsgBox is hidden by...