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 MintJulep 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: *

  • Users: Harley78
  • Content: Threads
  • Order by date
  1. 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...
  2. 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...
  3. 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()...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. Harley78

    4 CHOICES INTO ONE CELL

    You can see that I am trying to fill a cell on another worksheet, but with this code, it always ends up blank because A145 is blank. How do I keep this from happening? Range("A139").Copy Destination:=Sheets(1).Cells(279, 1) Range("A141").Copy Destination:=Sheets(1).Cells(279, 1)...
  9. Harley78

    Command Button Color Change on Click

    Me again, I didn't want to bother you, but have tried and tried to get the command button to change color when I click it. Nothing is working... so I am asking, is it possible? Private Sub Command1_Click() counter = counter + 1 If counter = 1 Then counter = counter - 1 End If If counter = 1...
  10. Harley78

    Cell and command button

    Was wondering if anyone has ever had the experience when clicking a command button that it will fill in a cell( e.g. A1) with the name of a command button that was pressed (e.g. HC12). Thanks all
  11. Harley78

    i know i know...

    Ok, i have been trying to put together a formula for days now, and can't seem to get it working. What I have so far in cell H53 =B53*C53*IF(Q53="MOH OK",1,1.1346)*IF(R53="$",1,1.29) (Now MOH OK and $ are drop down selections) B53=Qty C53 = Cost MOH and $ are...
  12. Harley78

    Formula's in command Button

    I hate to keep asking questions, but need some help on Formula writing inputed in a command button. I have never done this and seek your professional help. I have 25 cells that have percentages for Markup puposes depending on selection. e.g. 2.2L ( placed in Cell R2) is selection...
  13. Harley78

    AM I IN A DREAM WORLD?

    Before I begin, just wanted to check to see if I can do a macro that will take a row below and subtract the row above it for each line... However, the glitch is that there are different companies and some contain more rows than others so this would need to start over at that row with company...
  14. Harley78

    Row Hiding

    I have created a command button to hide rows.... depending on the cell. However, I am trying to unhide the rows but stuck as to how to achieve this. I also want the button to change names each time you select it. eg. All Data / Main Data. The macro I have thus far is which works great. My...
  15. Harley78

    Formatting Problems

    Maybe someone can help.... I have created a simple macro that copies a worksheet (in the same workbook)and inserts a new worksheet. However, the format is totally different. The copied worksheet is landscape, but when it copies and inserts, it changes the column(s) dims as well as portrait...
  16. Harley78

    CHARACTER REFERENCING

    I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me. if I have a cell that contains characters, e.g. Cell A10 contains OA/01 and now I am in Cell D4,(That already has a formula assign) I want to have this cell note that the...
  17. Harley78

    alpha character reference

    I have been beating my head and cannot seem to figure it out, hopefully someone with more smarts than I can help me. if I have a cell that contains characters, e.g. Cell A10 contains OA/01 and now I am in Cell D4, I want to have this cell note that the second character (in this case...

Part and Inventory Search

Back
Top