drawing

  1. Jaafar Tribak

    Drawing on UserForm Title-Bar and adding some cool formatting

    Hi dear forum, I am posting here some code that I have been working on in recent days. The code allows users to apply the following cool-looking niceties to their userforms: 1- Change the color of the Non-Client Area and optionally, add a gradient fill. 2- Change the Font of the caption text ...
  2. R

    Counta with If

    For whatever reason, I'm drawing blanks on this one. I'm currently using =COUNTA(tblCourses[Name]) to count the number of courses I have. I had to add a column to my table, tblCourses[State] and I intend to type "Inactive" if the course is no longer available. How could I modify the counta...
  3. M

    Automatically inserting row after enter, but range will change.

    Hello, I'm having a problem trying to develop a code that will enable me to automatically insert a row as enter is pressed. Sounds easy, problem is this needs to happen throughout the excel sheet. There are titles to drawing packages in the sheet, two blank spaces between each title. As...
  4. M

    Defining shape dimensions

    Hi Dears, I am trying to draw a 3d box (shape type 14) with VBA, but I cannot find the required parameter to define its depth. The width and height parameters are very clear, but I am unable to change the default depth of this shape. The command used to draw the box is; DIM MyShaep as Shapes...
  5. N

    Corrupt drawing in Excel

    Hi all, I'm getting an error message whenever I open up a particular workbook - it asks me to repair, if I say yes I get a dialog box that says "Excel was able to open the file by repairing or removing the unreadable content - Repaired Records: Drawing from /xl/drawings/drawing20.xml...
  6. USFengBULLS

    Multi-Criteria Vlookup Formula Not Working

    Hello All, I have a Transmittal column on a Drawing Schedule worksheet that I want to auto populate whenever users add transmittal data (This is being done by VBA Already and is working fine) to another sheet that is the Transmittal Log. some things to be aware of, this vlookup has to meet...
  7. R

    Specific result from Vlookup

    Hi, I,m trying to vlookup one cell value with the other. And I got the result also. But I want only one particular result if the cell values are matching. Rest results I want to keep blank even if its matching. For example I have a list of drawing no's in first sheet and second sheet have the...
  8. A

    Activecell.FormulaR1C1 throws a Runtime Error '1004' in Excel VBA

    This formula was written while recording a Macro. Works perfectly fine in a cell , but when trying to run from VBE ,its throwing a runtime error '1004'. Any help appreciated .... Thanks in Advance Sub Macro7() ' ' Macro7 Macro ' ' ActiveCell.FormulaR1C1 = _...
  9. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  10. C

    Collect Tab information to create a main list

    I am working with an excel workbook(google sheet) which has about 78 tabs. Each tab has information such as contact information, location, group name, etc. With all of that information I need to compose main list. As well as to reflect any information they add or remove. I thought of using the...
  11. W

    Reccomendation for Countif when data contains "2018"

    I am trying to create lookup table that will return certain criteria based on annual date ranges. So I have a data validation / drop down list to change from 2018, 2017, 2016. But I'm drawing a blank how to create a CountIf based on the year within the text of the cell range. I have done this...
  12. K

    Standard notes wizard

    I would like to set up a Standard Notes wizard for our drafters. For my example, we make three different types of drawings: Assembly, Welding, and Sheet Metal. I would set up a table with notes in the rows and drawing types in the headers. <tbody> NOTE ASSY WELD SHTMTL INTERPRET DRAWING PER...
  13. S

    Angled Cell Fill

    I have an excel sheet with all cells the same size (20 pixel rows and columns). I have top borders on range C2:Z2 and F18:AJ18 and I inserted lines to connect the end points using alt key so the lines connect in the corner of the cell. For the cells that get cut by the straight line (that's on...
  14. ebea

    Math problem (excel formula)

    Hi all! Are there out in the Forum, one or other person, with good math understanding? I need some help, to find a way to calculate an outer measure (outer to outer of the bend), on a pipe which are bended 2 times, in an angle on 180 degrees on each, and to make a formula in Excel, for this! I...
  15. D

    MACRO: seek, copy and paste only the last review of a drawing

    Hi everybody! I work in a technical office for a construction firm. As you can imagine, we have an Excel file with thousands detailed drawings regarding the construction. Every drawing is associated to a code, which is made up of various parts. I avoid to explane each part of the code, the only...
  16. S

    Document Control - Duplicate Values and Corresponding Columns

    Hello, I am building a spreadsheet to keep track of construction drawings. For those that do not know, these drawings will get revised from time to time, so it is important to know which revision is the most up to date. So far what I have is a column (Column A) which has a list of drawing...
  17. Z

    vlookup with multiple instances

    I have a list of over 1000 drawings in one column and the building the drawings are associated with in another column. I have another list of drawings I am trying to match the right buildings to using a vlookup but the problem I am having some some drawings have multiple buildings associated to...
  18. A

    simpler VBA code with a loop

    Hi to all I have a piece of code that is working, but i would like to make it simpler by using a loop. could someone assist me? bellow is my code: '%%%%%%%%%%% DELETE previous pictures from the worksheets%%%%%%%%%%%%%%%% 'Approval drawing 1 Dim myObj1 Dim Pictur Set myObj1 =...
  19. pcc

    Why does object redraw every time?

    Hi all. I have written a workbook that allows me to display chords for the ukulele (I am left-handed and I cannot find a left-handed version on the internet anywhere.) In order to do this, I have created a drawing object by grouping together various lines and rectangles, to mimic the fretboard...
  20. M

    Lost sheet formatting after re-open

    Hello I closed my PC for a week. After re-opening Excel give me a message that it did found some error and re-opened it. Now, my main page is displaying only the formula. No format nor drawing is shows. All drawing was linked to a macro. I don't found the proper way to explain the problem...

Some videos you may like

This Week's Hot Topics

Top