Search results

Narayan, Thank you for your help. I have looked at the file and tried to determine how to proceed but unfortunately I am afraid it is beyond my vba skills. I would greatly appreciate your continued assistance. I am not sure how to use the combobox ID to populate the correct field in the...

Hi: I have drafted up a sample of my problem. Here is the link. https://www.dropbox.com/s/fg50jrb7dbg79ur/txtbox%20userform.xlsm As you can see my table has a ton of combo boxes. For the sake of my question we are only concerned with the combo boxes in the 'Notes' rows (5, 9, 13, 17, 21)...

Thank you both for your help! Works perfectly!

Hello, I have to imagine this has been asked before....but I cannot seem to find a solution that has worked for my situation: I want to ensure that every field in my userform is completed before the OK button is enabled. In total the userform contains 9 textboxes, 2 combo boxes and 1 list...

I AM using dynamic named ranges. Please tell me this is not the issue. I have a graphs sheet set up, with 4 charts that have dynamic ranges (for each series and for category series) so that as the source range is updated, the charts reflect the update. I have some big IF and VLOOKUP formulas but...

Smallman, The reason I want to use vba here is because this whole sheet is populated by vba, pulling from the data sheet. So it is not like another column gets added to existing data, but rather the sheet is re-populated with this additional column. Hence the non-static starting point for the...

Thanks for your help guys. Smallman I would appreciate a followup as I still do not know how to reference the changing starting point and ranges when writing vba.

sorry that does not do a good job of laying out the problem. please see sample workbook https://www.dropbox.com/s/r7ih11dm4oumuc7/vba%20filldown%20example.xlsm

Hi, I have a list of data that will be changing. This list can span multiple months/years. I wanted to produce a "top 10 list" from this data. I can do this manually, through use of large formula but I want vba to be able to do this without referring to specific ranges. I am not too familiar...

Hi, I have a scrollbar that I use with a dynamic chart that goes scrolls through quarters of data. I am experiencing significant (2 sec) delay from when I click the scrollbar to when the chart reflects the update. Does anyone know what might be the cause of this delay? Thank you

Hi, I have a column that contains text strings and I want to count the number of times any cell in this column has a specific word in its text string...so say my column has values like: Meals-Breakfast Parking Meals-Lunch Lodging Taxi Meals-Snack Meals-Lunch Airfare Meals-Dinner Meals-Snack I...

I want a combobox that updates whenever a button is clicked. I have tried using a dynamic named range along with the .RowSource and .ListCount properties but have had no success. The combobox lists years that correlate to the present data. When a new year of data gets added, I want the...

I just figured this out...with the help of the articles here on Chandoo :). Selecting the range for data labels would give 0's where I wanted blanks...but if I go to each individual point and set that data label text box equal to specific label cell, the blanks no longer show as zeroes...

Hello, I have a simple bar chart listing employee data. I have cleaned it of the normal chart clutter (axes, gridlines, category name & legend) and want to add some dynamic data labels. I have added a combo box control to the chart as well as a dummy series so that you can select any employee...

Hi, Last week I was working with Excel 2007, and I had created a workbook that used the Microsoft Date & Time Picker a number of times. I have distributed this workbook to a number of colleagues...and have since upgraded to Excel 2010. Now, when I open the workbook, a big ugly red X appears...

Dhanushr, Do you just want synchronized worksheets? Post a sample workbook so you can be better helped. You can type "=sheet1!K7" in K7 of sheet2 and this will liveupdate whenever sheet1's K7 is changed. You can then use autofill to apply this to the necessary cells. This is probably not the...

Thats what I was hoping...thanks!

Hi, Talked with my boss today and he said the company will pay for me to go to Excel School!!! I'm a little excited. Anyways, before I go through with the purchase I wanted to know if there would be any issue with me accessing the program and materials from both my work and personal...

Hello, I am in the process of creating a nifty workbook (link below)--with loads of help from a handful of you ninjas--that takes raw data and uses a pivot table to organize the data to be used in several graphs. (I have not incorporated graphs yet). The user clicks the metrics button and is...

life as a ninja must be challenging! one last hurdle I can see that lies ahead: This whole worksheet event code is for a worksheet that will be deleted and re-created every time the user uploads new data. What is the best way to incorporate the code so that every time this worksheet is...

Doh! I realized I hadn't saved your file since working with it. Once I saved it started working properly! As far as I am concerned, I do not have anything that loads whenever Excel is opened. However, I do have one workbook with a lot of macros. Can you tell me why (or if) its important to...

SirJB7 I downloaded the updated workbook and I still receive the same error messages (unspecified and compile error:out of memory) when I select warning from dropdown. I think this is because of the userform and pdf incompatibilities. Private Sub Worksheet_Change1 references this userform...

I have done that edit, and now the code runs completely through but the desired cells of "thisRow" are not copied to the TargetSheet. I have triple checked that I am referencing the correct cells. Do you see any mistakes with the code below the trigger event?

Hi, Please review my code below. I have combined your code with the code that will copy certain cells to other sheet. It gives me an error code "Compile error: object required" when the code is triggered. The error points to this piece of code: 'Set thisRow = Target.Row' I have tried...

Thanks for the reference...although from my digging I am thinking the next best option of saving as pdf will have to be pursued. I still need to configure the dropdown list column to trigger this macro if Warning is selected. I have tried the worksheet change event route as explained here...