drawing

  1. E

    Trying to open a part drawing

    With VBA i need to open a drawing part from user form. I have all the paths and part numbers correct but can`t seem to hyperlink to the drawing part. It just goes to the message rather than open the drawing. Private Sub Open_Part_Click() Dim SourcePath As String Dim SubPath As String...
  2. L

    Drawing with text copied from OneNote (as image) only saves pdf as text, but prints normally...

    Lots of variables here, and not exactly an equation, but I'm hoping someone can help shed light on an issue. We draw diagrams with text numbers in OneNote, and then copy that drawing into an excel workbook as a picture (circle our drawing in OneNote, copy, right click excel, paste as picture)...
  3. 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 ...
  4. 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...
  5. 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...
  6. 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...
  7. 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...
  8. 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...
  9. 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...
  10. 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 = _...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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 =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top