Recent content by ReportMaster

Thanks everyone for all your great advice! I was able to do a lot of what I wanted to. One thing I could not figure out, even with some extensive web searching, is how to change the icons in excel. The Icons that I am trying to alter are the application icon (the one you click on to open the...

Skip, I have rng declared as a range. Here is my code: Private Sub cboPrimary_change() Dim r As Range Dim rng As Range Select Case cboPrimary.ListIndex Case 0 Set rng = Sheet4.Range("g5:g8") Case 1 Set rng = Sheet4.Range("g11:g16") Case 2 Set rng = Sheet4.Range("g19:g26")...

Hey all, I have a USER FORM in EXCEL with a frame inside of it. I also have option buttons. I am trying to program the option buttons to change teh background picture of the frame. I am trying to do this without pointing to a file on my hard drive (i.e. "C:\pictures\back1.jpg"). what are...

Skip, I declared r as a Range, but now another eror is occuring telling me that an "object required". It points to the same line of code as before, any suggestions?? tnaks for all your help, RM

Skip, thank you, your code was very helpful. It ran fine when I had it inside of a worksheet, but I have made some changes and it now lies inside of a user form. The first combo box populates correctly, but an error occurs when the second box tries to fill. it points to this line of code...

Hello, I am having trouble populating a speadsheet which is inside of a user form with data from a sheet in my workbook. I am trying to get the speadsheet inside of the user form to populate on activation. I am unsure on what the exact code would be for this or if there is a predefined...

Is it possible to change the icon in the top left corner of the screen?? Is it possible to change the header text so it doesn't say microsoft excel? Is it possible to get rid of the numbered rows and lettered columns? Anyone have any tips for making excel look as much like it isnt excel as...

VBAjedi, thanks for your help, but I am still a bit lost. I am thinking about a different approach because the criteria for filtering is never going to change, just month and year. Does anyone know if it would be possible to do something like this... if cboMonth.value = "January" then...

I have been unable to figure this one out. I have several sheets. Sheet 1 is the 'database' sheet. Sheet 2 is a 'report selection' sheet. sheet 3 is the actual reports. Sheet 1 has a month in the first column and a year in the second. They are just string and numeric fields...

I know that there has to be a simple way to do this, but I have not been able to figure it out. Say I have ten columns of info and 500 records. One column contains a month name while another has a year. How could I create a worksheet that would display only the records from a unique...

On one of my sheet I am trying to get all of the values for a certain column ( say column 2) to populate itself with specific data. The data must be pulled from another sheet depending on the value of a cell in that same row ( lets say this would be all the values in column 1). The value of...

I am trying to fill a combo box in excel with a data range from another sheet in the workbook. I have one combo box, say with a list of choices from 1-5. I want the second combo box to display multiple values from a range of cells in another sheet in the workbook based on the selection from...

Hi, I am working with VBA inside Excel. I have multiple worksheets. I have designed a form interface on one where there are five text boxes (say sheet1). When the button is clicked I need all of the values of the textboxes to be added to a single row of another worksheet(sheet2). Thanks for...

I am currently attempting to write a simple accounting program with visual studio.net. It needs to store information like 'check number', 'amount', 'expense category', and 'paid to' to an independent file. I also want to pull the information out to give a ledger style report of expenditures...