Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Harley78

    Count Cells with Data

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

    Count Cells with Data

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

    Listbox & Labelbox

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

    Command Buttons

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

    Command Buttons

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

    Command Buttons

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

    Command Buttons

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

    Command Buttons

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

    Command Buttons

    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()...
  10. Harley78

    counting unique digits

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

    counting unique digits

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

    Option Button & List Boxes

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

    Concatenate two listboxes in a textbox

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

    Concatenate two listboxes in a textbox

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

    Concatenate two listboxes in a textbox

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

    LINE OR LINES INSERTION AND COPY

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

    LINE OR LINES INSERTION AND COPY

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

    LINE OR LINES INSERTION AND COPY

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

    LINE OR LINES INSERTION AND COPY

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

    4 CHOICES INTO ONE CELL

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

Part and Inventory Search

Back
Top