Search results

Thanks for the reply SpentGeezer, but I had already tried the Excel Forum some time ago with this and didn't get it worked out. As it is Visual Basics I thought this forum might be able to help. I am managing with the programme as I have developed it, but I would like to get a better solution...

I have 3 events that need to work when certain cells are changed. The first 2 events are identical, but are set up to look at different ranges of cells within the same Excel worksheet. Each one works fine on its own, but won't work together. So I put 1 in the Worksheet change section and the...

Oh, I see what you mean. I didn't think this would be necessary, when I have specified the cell addresses that each function refer to. I'll try this. Thanks for the help. rgs Ginny

Hi Brian, I'm new to Worksheet_Change, I'm afraid. My understanding is that by putting the code there, it would be triggered each time a change is made in the worksheet. If I put the code into functions there, would they then need to be triggered? Yes, that line of code is probably wrong...

Thanks Sunshine076. I'll have a read up. I changed my second function to read: n=Target.Column If Cells(168, n).Value = "Quota >Req'd" Then ... This has helped. It's not fully right yet, though. It's not producing the correct results all the time. rgs Ginny

Hi all, Thanks to Craig Ottley and Batman in the Ozgrid Forum I have been able to set up functions in Worksheet_Change(). My problem is that each function will work correctly on their own, but when I try to put 2 functions together, I can't get them to work independently. Is this possible? '...

It's a simple database that produces some reports for us. We input reports in 1 format and the database reformats them into a more user friendly format. I presume at the time the employee who created it, just wanted to make sure it was secure, but now that the employee is no longer with us and...

Hi all, I am using a database that was created years ago, which has the vba password protected. I don't know the password and would like to make some changes to the design of the reports that are output. Can anyone help? rgs Ginny

Thanks Holger - works a dream. I can't believe that was all that was wrong! rgs Ginny

I want to populate a listbox with the data in column B dynamically. So I am adding the following code in the userform initialisation. It stops at the .AddItem cellValue line. My listbox value is appearing as nothing. Dim r As Long Dim RequiredRosterDWSText As MSForms.ListBox Dim...

I figured it out. rgs Ginny

Hi all, I'm using VBA in Excel with a userform which initialises with textboxes. The number of textboxes that are created are dependent on the number of records in a worksheet and each textbox is populated with the data in the cells. This works perfectly, what I want to have happen is a...

Maybe I'm reading this wrong, but anytime I create a Line Chart I include the Cols or Rows that contain the blank cells that will update. On updating the data the Chart updates. Ginny

Is your date in the right format in the sheets that won't allow the extend series? The date must be recognised correctly by Excel. Try a simple test in those sheets. Type the date in 2 formats - 01/01/2010 and also 01.01.2010. The one with the "/" should extend, but the one with the "."...

Thank you Holger, I hadn't realised that was available!! Silly me :-). Appreciate the help rgs Ginny

Hi Matt, I have reproduced the above function and it seems to work perfectly ... but ... it does appear to struggle on large amounts of data. Maybe it just has too much work to do!!! I set up 4 columns with 43000 rows. I then added a column of search items in another part of the worksheet...

Yes you can. Add your Nested If Formula to the source field in the Data Validation dialog box. =IF(A1="one",List1,IF(A1="two",List2,List3)) where "one", "two" and "three" are the value in cell A1 and List1, List2 and List3 are named lists set up in separate columns. Works for me. (You can...

Hi all, I would appreciate help with above. I have coding as follows: ChDir _ "Z:\SAP_HR\Ginnys_Folder\" as part of an Open File sub routine. My directory will never change although the file to open will have a different name each time. Here's my problem. The above works...

Yes, David, I know I shouldn't be using list boxes on the reports. The amount of data that I am reporting on makes it too tedious to create text boxes for every value. Combo boxes will not work at all. I am going to investigate if I combine all 9 queries into 1, if that will allow me to...

That means I have to change every query that I have built. These were already formatted using the Property option within the queries and set to standard. Isn't it most annoying that the Reporting area in access 2003 cannot cope with using this facility!!! All other versions of MSAccess can...