Input box function in 2007

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I don't see how the Input Box function works in 2007. Used to be that you
could set the type for =8, and when you used the function, you could click on
a cell, and the contents or the cell reference was returned. How would I
replicate this type of action in my 2007 Macro?
thanks
 
Inputbox function or Inputbox method? Inputbox method is/was

Application.Inputbox(Prompt:="Select Range", Type:=8)

I don't have 2007, so can't help you any more than this.
 
I think I found the issue -- but that brings up another. In 2007, there are
even tighter restrictions on Macros. Once I reset my Macro Security level to
the most lax, the Macros seemed to run smoothly again. The question I have
now is how to create a "Digitally Signed" macro?
 
Never dealt w/digital signatures. You might search this site for
information, I know others have asked about it. Some have mentioned using
selfcert.exe or making the workbook an add-in. Don't know how that applies
to 2007. Sorry I can't help you more.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input box display 2
VBA set thick borders around non empty cells in range 0
User defined function 5
macro to set bottom and top values for randbetween 6
Countif Code 3
Accessing the Bessel Function within VBA in Excel 2007 6
Code for multiple select of cells 16
VBA Countif across sheets? 5

Back
Top