Recent content by Harley78

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...