Search results for query: *

thats weird, it calculating, 11041398 and not 16. Is there something I am doing wrong?

I am trying to write a formula, but i am stuck. MAIN SHEET - In column A, each cell contains order# (text or number) Then in column EE there will be a month that this order came in. Now on my SUMMARY SHEET I have the below formula in C191 (B191 represents the month), but not getting the...

I have a question and I am stumped. I have a userform1 that is filled then when a label28 is pressed a userform pops up with a listbox (multi selection). and a label underneath for the merging of the selections. Now I am stuck trying to make this work and also how would I make it that the...

You are correct, however it is much faster to change the button name than it is to change Cell, and button name. Thanks so much for the great idea.

That is basically what I was doing with all the fancy macro's. However, I wish the button would get darker instead of light when true. Otherwise that would be easier. Thanks so much for your suggestion.

Thanks Pete, and here is what I am doing. I have basically a visio drawing in Excel. This drawing allows one to configure a complete part (this example a wheel). Example. Rim, Spokes, Tube, Tire. each one also being a different size. So this worksheet will have 16 command buttons. I...

I am so sorry... I have already done the command buttons and assigned the codes. I was just wondering if there was a shorter example method of the code so each one doesn't have to receive the code in my above post.

Thats my problem, I do not have a clue on how to that. Can you help with an example? I appreciate your input.

Currently I have anywhere from 5-32 command buttons on each tab (worksheet)which I have 32 worksheets. Each Command Button Will change color if selected as well as enter data in a cell that I specified. As well As if selected again...... See current code, Private Sub CommandButton38_Click()...

I have never done that, can you enlighten me on what this is and how to use it?

I am trying to figure out how to create a formula to do the following. Hopefully someone can steer me in the right direction. (SHEET 2008) Column A is order #, Column B-E is ECO Column F-I quote # and Column J is Month SHEET (BTC) Trying to create a formula so that it will look in Sheet 2008...

How is the code written so that when a userform is open that it shows what was in the cell that it refers to? I have 6 yes & 6 no option buttons and 8 list boxes. The code I have thus far reflects what should be filled and where it should go on the worksheet, but don't recall how to make it...

Here is the code anyhow. I noticed that it is not working exactly as stated because of the code below.... I just need to see what I have to tweek for it to work... Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim UForm As UserForm33 Dim Sel_Row As...

Ok, to start,,, I double click on a row in which I want information stored....and the Userform comes up. Within the userform... the two listboxes are exactly alike.. have A, B, C, D, E, F in each one, designed for Rev change. So what I am trying to achieve is the user clicks on the selection...

Just wondering if someone can help with the macro to Concatenate two listboxes in a textbox. I have tried but I can't figure it out. I have two listboxes filled with selections from BTC sheet, these listboxes are on a userform. The two are exactly alike since it is designed for rev changes. I...

So sorry to be a PITA.... Are you saying that it can only be done, if the headings were attached in each worksheet? Which means i would have to manually enter this each time... if this is true, then I suppose i need to check other options.. or just forget this whole idea of automation...

I know, i know, my explenations are terrible.. and very sorry.. At the bottom you see Sheet 3 Row 12 Column D, So what I am trying to explain ( terribly at that ) is that when I Click a "command button" (failed to mention that)that it looks through all worksheets.... notes a numerical...

Maybe this might help Sheet 1 Column B Row 1 5410-6020(0)M-4719-F Row 2 5410-6020(2)H-5030-R Row 3 5003-5410-6015 Row 4 7503-310p-6620 Sheet 2 Column A Column D Row 4 1 123594 Row 9...

sorry to be asking so many questions. but have been perusing through to find something that can help, but can't find it or i don't know what I am looking at. Anyway, my question is. if I have typed a 1,2,3... and so on, in column A on sheet 2, rows 2, 9, 13( now each can be different each time...

I agree handleman... an important notation in which I did not provide. Sorry about that and thanks for all your help!