Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collect User Input
Can VB programing within Excel, take the user's Input.
Can a macro run and get the Font Name and Font Size? If so, how is this done? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collect User Input
On Saturday, March 2, 2013 3:24:10 PM UTC-8, JCO wrote:
Can VB programing within Excel, take the user's Input. Can a macro run and get the Font Name and Font Size? If so, how is this done? Thanks Hi JCO, Try this. Option Explicit Sub FontIt() Dim i As Variant, j As Variant i = Range("A1").Font.Size j = Range("A1").Font.Name MsgBox i & " " & j End Sub Regards, Howard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Collect User Input
JCO wrote on 02/03/2013 :
Can VB programing within Excel, take the user's Input. Can a macro run and get the Font Name and Font Size? If so, how is this done? Thanks Why do you need to prompt the user for this? Is their some reason why the user can't just select these from the toolbar control[s]? Otherwise, you'd need to use the VB6 Common Dialog control, which would have to be distributed with your VBA project. A VB6 developer license is required to use/distribute the control in your projects. Perhaps you can google to see if someone has written a pure VB font picker that you can modify to work in a VBA userform. Or maybe there's a DLL available! -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form instead of message box to collect data | Excel Programming | |||
User Function Question: Collect Condition in Dialog Box - But How toInsert into Function Equation? | Excel Programming | |||
Macro to collect rows with user-specified cell value | Excel Programming | |||
use Excel2000 as web interface to collect user input? | Excel Programming | |||
CODE to select range based on User Input or Value of Input Field | Excel Programming |