Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box function in 2007
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box function in 2007
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. "Bob-wants-to-know" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box function in 2007
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? "JMB" wrote: 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. "Bob-wants-to-know" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Input box function in 2007
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. "Bob-wants-to-know" wrote: 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? "JMB" wrote: 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. "Bob-wants-to-know" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Input form in Excel 2007 | Excel Discussion (Misc queries) | |||
Data Validation in Excel 2007 - Input Message | Excel Worksheet Functions | |||
how do I creat an input form in excel 2007 to include drop down bo | Excel Discussion (Misc queries) | |||
How do I set up the column input value in Microsoft 2007 | Setting up and Configuration of Excel | |||
How do I input address data into a table in Excel 2007? | New Users to Excel |