Insert active Buttons for Charater Directional Arguments

Re: Insert active Buttons for Charater Directional Arguments

I am not sure why you are asking this again. I already answered it at: http://www.excelforum.com/exce…ead-of-drop-down-box.html

Do you not know how to insert ActiveX or Form controls? Your file already has one form control so I would assume that the answer is yes.

Re: Insert active Buttons for Charater Directional Arguments

I am not interested in stars. I am interested in helping.

Adding a command button is so basic, I would suggest that you learn. There are many tutorials that explain how to add either an ActiveX or a Form control. It is best to try learning how to do that. Here is one: https://support.office.com/en-…04-4964-bead-9c72c843a283

I used to prefer ActiveX controls but after Microsoft did an upgrade, many users had problems. Form controls is what I use now.

So, add the routines that I showed you in the other thread into a Module. Create the form controls and then right click and select the appropriate routine that I created for you. From the code for the two routines, it should be obvious that you would copy and paste those and just change the Sub's name and the value for the direction and you will be set.

You can right click your existing form button and Edit to view its macro code.

Re: Insert active Buttons for Charater Directional Arguments

That workbook is the one that I wrote to answer your question about directional printing.

There is already a UDF formula in H2:P10 that has E2 and F2 as arguments. No button is needed.

The button that is already there, takes its direction from F2. (But the string "see this" is hard coded for demo purposes.)

I don't understand what refinement you want.