Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Designing
I have created a bunch of Macros for formatting and such. Can a Macro be made
to enter text? Steve |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Designing
Sure. Explain a little more though on what you're trying to do.
"Steve COR" wrote: I have created a bunch of Macros for formatting and such. Can a Macro be made to enter text? Steve |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Designing
Well, it's not clear what you're asking to do, but here's a part of a
macro which prompts a user for information and then inputs that information into a specific cell. Sub CalculateWACC() Dim MyString1 As String Worksheets("Analysis").Range("A1:A7").ClearContent s MyString1 = Application.InputBox("enter required or expected return on equity") Worksheets("Analysis").Range("A1") = MyString1 On Aug 7, 10:32 am, Steve COR wrote: I have created a bunch of Macros for formatting and such. Can a Macro be made to enter text? Steve |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Designing
Sub entertext() Range("d1").Value = InputBox("Enter text") End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Steve COR" wrote in message ... I have created a bunch of Macros for formatting and such. Can a Macro be made to enter text? Steve |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro Designing
I am trying to create a macro that will add two checkboxes Yes "box here" No
"Box here", with a Macros for with the set with the "Yes" checked and a Macro with the set with the "No" checked, and so on to cover all the possible combinations. I have successfully, about 5 minutes ago made a Macro to add both boxes, but I could not change the boxes to have the check in them. I delved into the VB side of the Macro but do not know what the handler/switch/whatever it is called to indicate the box should be checked. Here is the VB: "Selection.TypeText Text:="YES " Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormCheckBox Selection.TypeText Text:=" NO " Selection.FormFields.Add Range:=Selection.Range, Type:=wdFieldFormCheckBox" Basically how do I change: "Type:=wdFieldFormCheckBox" to show the yes box checked? "Mike" wrote: Sure. Explain a little more though on what you're trying to do. "Steve COR" wrote: I have created a bunch of Macros for formatting and such. Can a Macro be made to enter text? Steve |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Designing a spreadsheet - a brief guide | Excel Discussion (Misc queries) | |||
Designing a spreadsheet - a brief guide | New Users to Excel | |||
Designing a spreadsheet to track workflow | Excel Worksheet Functions | |||
Designing a Form | Excel Discussion (Misc queries) | |||
designing and linking | New Users to Excel |