Search results for query: *

My (training) client needs a way of being able to use Sheet2 of a Workbook to update values in a List stored in Sheet1. It's my birthday and I don't need this today!!!! The breakdown is: Make a Text Entry in Sheet2:A2 to search for, Search Sheet1:Col G for exact matches of the (Sheet2:A2)...

A predecessor of mine who was familiar with VB, wrote a model with the following command. Application.CommandBars("WORKSHEET MENU BAR").Controls(1).Delete It has deleted the menu bar throughout excel and I cannot get it back. I fear I may have to re-install Excel, is there an easier way! Can...

Hi I've created (and stole!) the 3 functions below, the first 2 taken from Tek-Tips to work out the Start and End of Months the 3rd Created by me to work out how much a customer should be billed for storage based on Total Days something has been stored in that month (MonthOfCharge) multiplied...

I have a combo box on a form which displays the list of fields for that form. When I make a selection I want it to fill out the value of the field selected into a text box below. At the moment I have managed to return the name of the field, but not the value with the code given below. The combo...

Hi Could you please help? I have a v. large spreadsheet (30Mg) that is linked to several others. Problem being the formula link is a SumIF, it will only update when the other worksheets are open. Otherwise there is a #Value error message in the cell. The formula must be created in a separate...

I'm trying to pull out all the Memberships in a Report that expire in a particular Month i.e. July 2003 (UK Format 07/2003) I can pull the appropriate records out using the Query Criteria: Like *07/2003 Can't seem to get it to work with a Parameter Prompt instead. The field it's using is a...