Show format in formula bar
On some spreadsheets I have #'s in the billions added together in
cells. Sometimes it is difficult to verify the number is 10,000,000,000
because it shows up as 10000000000. My eyes get crossed counting the
I'd love if the formula bar would show 10,000,000,000; however, can't
seem to find a way to do this. Is this possible?
No, you can't change the number formatting in the formula bar.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Native" <firstname.lastname@example.org> wrote in message
n...How to trap every left mouse button down as WM_LBUTTONDOWN (want to ignore double click)
How can I trap each left mouse button down event as a WM_LBUTTONDOWN? If I press the mouse button twice within the double click time, I miss the 2nd LBUTTONDOWN and get a LBUTONDBLCLK. Is there a property to set or is the technique simply to have the same code in the doubleclick event
"Yasoo" <email@example.com> wrote in message
> How can I trap each left mouse button down event as a WM_LBUTTONDOWN? If
I press the mouse button twice within the double click time, I miss the 2nd
LBUTTO...Macro Help 05-20-10
how do i assign a value of a cell to a variable in a macro
This sets the variable:
Dim r As Range, v As Variant
Set r = Range("A1")
v = r.Value
to set the cell, reverse the equation.
Gary''s Student - gsnu201003
> how do i assign a value of a cell to a variable in a macro
...Creating a combination chart using cluster column & stacked bar t.
I need to create a combination chart, using cluster column and stacked bar
types. I need to "cluster" two columns side by side without space in
between, with stacked bars within each of these columns. Then, have space
along the x axis, and have 2 more columns clustered made up of stacked bars
I am charting 2 years side by side, with different types of data within the
columns, so need to stack/segment the column.
How do I create and combination chart, and how do I select these 2 types to
If you stagger your data, you can create sid...Changing menu bar height
is there a way to change the menu bar height of an application?
I dont see how that can be done without replacing the whole menu mechanism. You can do
that if you want by putting in a toolbar/rebar which acts as a menu. Example MFCIE shows
how to make a toolbar as a menu. YOu can change the height of the toolbar/rebar to what
Ajay Kalra [MVP - VC++]
"Nicolas Bonamy" <firstname.lastname@example.org> wrote in message
| is there a way to change the menu bar height of an appl...Cant re-assign a task to yourself once allocated to someone else
Hi, we use a job funnel to group all the upcoming tasks together, then
someone allocates them out. But they cant allocate any tasks to themself. The
"Owner" keeps changing back to the origional name the task was assigned to.
Creating a new task and assigning it to yourself works fine.
Re-assigning a task to anyone else also works fine.
Is this a bug or a permission issue?
Rohan - was a bug introduced in Rollup1 and has been fixed, apparently, in
Rollup 3 which was released last week.
if you look at the KB for Ru3: http://support.microsoft.com/kb/961768
you can search it for t...Fire Macro from custom button?
Is it possible to initiate a macro via a button instead of from the bottom
Thanks - dave
1112 Ocean Drive
Manhattan Beach, CA 90266
Not directly from RMS, but you CAN call a COM Component from a custom
button and use SendKeys to trigger your macro from there. Code to build
such a component has been posted here in the past, but it has probably
fallen off the server... If you search this group through Google Groups,
there is more history and you should be able to find the post...
Tiber Creek Consulting
glen...Resource Scheduling Button not enabled
I receieved wonderful advice here about how to create resources to be
scheduled on my new exchange server -thanks everyone.
I am working to make it so! When I log in as the resources in question,
however, their button in Tools-Options-Calendar Options that says "Resource
Scheduling" is disabled and greyed out. In my mailbox its just fine. Is
this a permissions issue? something else?
Thanks in advance!!
...Conditional Formatting and Buttons
I'm working on a project and I'm stumped at a particular point. I hav
an initial page that contains several "option" buttons. What I a
trying to accomplish is that upon selecting 1 button from each of the
categories(11 possibilities in total) I would like to have them setup s
that it will access specific "names" that I have created.
Is conditional formatting the appropriate manner to do this?
Any comments or suggestions will be greatly appreciated.
Message posted from http://www.ExcelForum.com
i am not sure if i understand you corr...Help Text for Radio Buttons
I am trying to create a survey form with multiple choice radio buttons. I
want to add descriptive text that appears when you float your cursor over the
button (like that for a toolbar icon). I've scoured Excel help and couldn't
find anything. I don't have experience with macros or Visual Basic but am
willing to try if someone can hold my hand through it.
If the radio button is in a cell, add a comment to the cell. Then the
instructions will appear when the mouse hovers over the cell.
Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th...Label a button from a cell content
Using Excel 97, is their a way to aquire the label for a button from
cell on a different worksheet? :confused:
Thanks in advance,
spyrule's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2548
View this thread: http://www.excelforum.com/showthread.php?threadid=38935
...Excel hanging (macro use)
Can anyone help?
I'm running Office 2000 on Windows 95. I've previously been able to
open an excel spreadsheet containing macros but today it's just
hanging. I've tried restarting but still can't get into the app.
I click on the Enable Macros button and it just hangs.
Anyone have any ideas?
Message posted from http://www.ExcelForum.com/
Can you open it without macros enabled? Can you open it with a different
user profile? Try uninstalling any Add-ins you have and see if that works.
"fergusor >" <&l...Converting an MFC app from VS 6.0 to 2005
I'm just converting a VS 6.0 project to 2005. The project is compiled
now but I had a problem with AfxGetThread() not working the same way on
2005. The MSDN documentation was very clear and I fixed it but ...
What about other API's that have changed? Is there a list or a tool to
find them and report any potential problems with the code? Otherwise
I'll have to rely heavily on testing the entire app (which I've never
"Peter Smithson" <Peter_Smithson@hotmail.com> wrote in message
news:email@example.com...Tool Bars and Fonts for Desktop
I would like to increase the size of the Task Bar Icons, Tool Bars and the
font used to display files in Windows Explorer . . . and don't know how to
do that. I will be grateful for some help on this.
I am running Windows XP Home SP3.
Reduce the desktop resolution, effectively making everything look larger.
> I would like to increase the size of the Task Bar Icons, Tool Bars and
> the font used to display files in Windows Explorer . . . and don't know
> how to do that. I will be grateful for some help on this.
> I am runn...Deleting Macros
Having created a couple of macros within a workbook for a particular topic
and then deleting them when they were no longer required, I still get the
"Disable - Enable" Macros prompt when loading the spreadsheet. As there are
no macros associated with this particular spreadsheet can anyone tell me why
it still appears? And how can I prevent it from appearing each time I open
PS. I have also noticed this point previously when simply copying a
worksheet from a workbook containing macros to a new workbook without any
Thanks in advance
You also have...Visually Surpressing A Macro
I run Excel 2000
I was wondering if there is some code that I can use to visually supress a
macro when it runs.
When I presently run a macro that initiates a number of various tasks the
sheet "jump's" about as the macros run. Its not a big deal but would be nice
if I could surpress this screen movement.
Is it possible?
Application.screenupdating = false
your code that jumps around
Application.screenupdating = true
It may make the code easier to update if you drop all the .selects and
..activates. Just work directly with the range (for example).
worksh...Importing data via macro
I want to create a macro, which let me automate the process of importing the
data from various files (*.xls) from a particular directory to the main table
in MS Access.
My Main table in access is called Wire Transfer Main table. And every
Monday few specialist go in a share drive and post their completed forms in
..xls format. My macro should go into that shared directory every week and
pull out the files from that directory and copy the data from those files to
my Wire Transfer Main Table in access database.
Liz - you're probably better off if you writ...Disable Close Button
Does anyone know of a way to disable the close button (top right cross) to
prevent users from accidentally closing Microsoft Outlook?
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-What do the Outlook Icons Mean?
-Create an Office 2003 CD slipstreamed with Service Pack 1
"Ian D McLean" <IanMcLean@itp.uk.com> wrote in message
> Does anyone know of a way to disable the close button (top right cross) to
> prevent users from accidentally closing Microsoft Outlo...Macro or scripting help
I have a spreadsheet that goes to column P. All cells have data except for
Column M. Half of column M contains data and the rest are empty cells. I
need to copy or move all data rows associated with the cells in column M
that contains data. Normally I would be able to do this by just recording
macros, but data is constantly being added.
Hope I explained this correctly. Any advice is greatly appreciated.
The below suggestion uses autofilter to only show those rows where
column(M) is nonblank, then copy all
of the visible rows to your destination. You didn't ...MACROS!!
Hiya Could someone explain what a macro is?? and how i would do one?? (any
example will do!)
P.s.I can't access certain sites on the internet so please do not provide a
"Do you know where you're going to?"
Are you learning Excel in (very) small steps from the NGs? <G>
Normally I would direct you to David McRitchie's page, but I know what you
A macro is a VBA procedure that can perform an action, or a series of
actions. For instance, it can be a simple Hello World example
Sub Hello(...how to enable font button within mail format tab
I am trying to change the font size for composing email
with outlook 2002. When I click, tools, then options,
then select the mail format tab, my font button (under
stationary & fonts) is greyed out. How do I get this
Font button only appears in HTML mail. Change the format in the email and it
will be available.
> I am trying to change the font size for composing email
> with outlook 2002. When I click, tools, then options,
> then select the mail format tab, my font button (under
> stationary & fonts) is greyed out. How ...Newsgroup Button
Yes it worked. Thank you.
...Enabling Macros #4
Is there anyway possible that for every user that opens a
workbook with macros the Enable Macro question box will
not pop up and the macros will always be enabled? The
workbook that I am creating will be used by many people
with different versions of Excel and limited knowledge of
Excel so the macros may be disabled causing errors.
Thanks for the help!
the only way would be that your users set the security level to 'Low'.
BUT I wouldn't recommend this. this is a security feature. So there
should be no way tro disable it programmatically :-)
Frank...Drill down pivot table data via VBA macro
I am trying to create a macro that will drill down subtotals from a
pivot table. Since the number of rows, and colums, changes frequently I
need to reference the total for the row or column. Can this be done via
jmon76's Profile: http://www.thecodecage.com/forumz/member.php?u=1909
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=204538
Excel 2007 PivotTable
Show subtotal details via macro.
Define subtotal with PivotField...Conditional Statement in a Macro
I have a time sheet program with a pivot table on each sheet to sum the hours
worked on each job #. Each pivot table is named pivot table 7. I have set
up a macro to update the pivot table easily. It is as follows:
' Update_Pivot_Table Macro
' Keyboard Shortcut: Ctrl+p
Thus, since each table is named "PivotTable7" the macro works on any of the
I have added a pivot tab...