Search results for query: *

Hi Everyone I am using Excel from the Microsoft Office (2003) package. I have created a userform with combo boxes allowing the user to make certain selections. Lets say that ComboBox1 has the added items: "0", "1", "2" when the userform is initialized. I require the user to select one of...

Hi everyone I am using Microsoft Office (2003) and i've created a userform that allows the user to input values into text boxes which are later populated onto a spreadsheet. My problem is that i am struggling to clear all the textboxes afterwards (there are many of them). I've tried this...

Hi there An abbreviated version of my problem is that i have a set of 4 numbers for example (1, 2, 3 and 4) and i would like to be able to have an object which holds these 4 numbers where any one of them can be randomly chosen. If, lets say, 2 is randomly chosen, then i would like that the...

Hi there I have a form which updates a mini database in excel (2003). Once details have been submitted by the form to the workbook, it would be good to have the option to reset the form i.e. reload the form with original blank text boxes, populated list boxes etc. My question: is there a...

Hi Im in the process of designing a form in excel which captures certain fields and then inputs the data into the relevant places on a spreadsheet running in the background. My problem is that when i check for errors, e.g. a blank field ... ***** Select Case busname Case ""...

hi there Im trying to update charts in excel using named ranges. To simplify lets say that the x-axis comprises 12 months (jan -> dec) and the y-axis has 2 sets of data, a 'target' series and an 'actual' series. Lets say that the values for my 'target' data series are found at...

Hi there I dont think this should be too difficult ... In Excel, how does one return the row number of the current active cell in the worksheet? Thanks

Hi On a multipage form, lets say with 2 pages. Is it possible to reference a value from a textbox on page 1 when code is executed due to the clicking of a command button on page 2? So far i have not been able to add arguments to the procedure: Private Sub cmdInput_Click() Any help would be...

Hi I've written a marco to perform a series of operations on some data. Is it possible to bring up a message, similar to a message box, excepting that it does not interfere with background calculations or require input from the user befor it can proceed. Ideally, is it possible that the...

Hi there I've got a form which runs on top of a spreadsheet. I use the form to add and edit entries. My problem is that whilst the form is running the spreadsheet is not accessible ie. can't click on any cells or scroll through the spreadsheet. Is it possible to make the background accessible...

Hi Im wanting to know if there a way to print a single document so that four copies of that document appear on one page. eg. If your document consists of a picture of a rabbit then your printout has 4 rabbits in 4 frames on the page. Any help would be appreciated. Thanks

Hi My question is: Can you make a keyboard shortcut to run a user form like it is possible to do with a macro. OR Can you just initialise a user form from a macro? how? Thanks

Hi Selection.FormulaArray = _ "=SUM(IF(SMAST2!R2C92:R10976C92=""A"",1,0))" The above line comes out of a macro i use to sum the number of products in a list assigned an "A" in the range, (row 2 -> row 10976, column 92). The formula works well, i got it by using the record mode. Question...

Background simple eg. A B C apple pear FALSE grape apple TRUE orange pineapple FALSE Using formula array: ={OR(EXACT(B2,A2:A4))} and fill-down in column C to get answers. My Question: For different lengths of column A, how can one use an input...

Background simple eg. A B C apple pear FALSE grape apple TRUE orange pineapple FALSE Using formula array: ={OR(EXACT(B2,A2:A4))} and fill-down in column C to get answers. My Question: For different lengths of column A, how can one use an...

Hi My problem: I need to manipulate different worksheets of varying lengths and it is not convenient to scroll through my macro code and change the ranges. Is it possible to set up an input box, eg. Length = Application.InputBox("Insert the rumber of rows.", "Query", , , , , , 1) And then...

Hi The problem: There are two columns of product codes. The 1st is for the original part and the 2nd its replacement code. eg. Orig Part Repl Part A0000000299 83091446038 A0000000320 A0000002404 . . ...

Hi, please excuse any general ignorance, im a newbie at access. The problem: There are two columns of product codes. The 1st is for the original part and the 2nd its replacement code. eg. Orig Part Repl Part A0000000299 83091446038 A0000000320...