ömür tokman Jan 11, 2019 8:20 AM
Knowledge is gold .
Thank you for sharing.
I added to my favorites, I follow.

We are very "fortunate" because you are not a programmer.
programmers do not share this information. (the exception proves the rule)

Edit:
By the way! When you publish macros, it's perfect if you add a few screenshots.
Like • Show 7 Likes7
Actions
Fatih Mehmet Ozcan Jan 11, 2019 8:27 AM
Thanks.
Like • Show 5 Likes5
Actions
Madson Germano Jan 11, 2019 8:46 AM
Thanks Rob Edwards

Could you explain a bit further what advantages you found of programming the whole property manager page over, let's say, just creating a userform?
Like • Show 4 Likes4
Actions
- Rob Edwards @ Madson Germano on Jan 11, 2019 8:58 AM
  Hi Madson
  Mostly for the familiarity of the UI.
  But my ambition is to write macro features and learning how to use the property manager page was a stepping stone towards this.
  It's also possible to dynamically create a property manager page on the fly.
  Like • Show 5 Likes5
  Actions
ömür tokman Jan 11, 2019 10:33 AM
Can you please add it on this page, every macro you publish.
it is very nice to reach from one page.
Make Table From Sheet Names Macro
Like • Show 2 Likes2
Actions
- Rob Edwards @ ömür tokman on Jan 11, 2019 11:21 AM
  ömür tokman wrote:
  
  Can you please add it on this page, every macro you publish.
  it is very nice to reach from one page.
  Make Table From Sheet Names Macro
  Will do ..but I might add a few more yet.
  Like • Show 1 Like1
  Actions
Josh Brady Jan 11, 2019 10:38 AM
Say Rob,
When you get done with yours, could you organize mine? Thanks!
Like • Show 5 Likes5
Actions
- Rob Edwards @ Josh Brady on Jan 11, 2019 11:13 AM
  I might be a while Josh... yours look mega organised.. I've got all kinds of junk and many that just say macro1. I'm so messy
  Like • Show 1 Like1
  Actions
  - Josh Brady @ Rob Edwards on Jan 11, 2019 11:40 AM
    If by "Organized" you mean "at least mostly in one folder", maybe. Accumulated code from a few years. I probably couldn't tell you what half of 'em do without opening them.
    
    On the theme of posting code for posting's sake, here's a snippet I made several years ago because I wanted a MsgBox and an InputBox, but I wanted to be able to zoom/pan/rotate, or make selections, or etc. before answering. Of course, the standard MsgBox and InputBox are Modal, so you can't do that.
    
    All you need to use this is to import the .frm file into your VBA code. Then, anywhere you would have used a MsgBox, instead you use the line
    
    nAnswer = YesBox.GoBox(Message, Caption, vbYes) 'or vbOK
    
    It's not done in the most super-correct manner, but it's the simplest way I found to get the functionality using a single line in my main code.
    
    I've attached an example macro that uses it as well.
    Attachments
    YesBoxSimpleImplement.swp.zip20.2 KB
    YesBox-InBox.zip2.5 KB
    Like • Show 2 Likes2
    Actions
    - Rob Edwards @ Josh Brady on Jan 11, 2019 12:08 PM
      Fantastic
      That would be perfect for the sketch cleanup macro, so you can examine what has been selected before hitting delete.
      Like • Show 1 Like1
      Actions

My Macros...

Outcomes

Attachments

Related Content

Recommended Content