Show range of cells in a userform
I would like to create a macro that shows a result in a userform (e.g.
a userform with tabs)
The result is a range of cells. How do I do this? The range has to be
active in the userform, so that I can tic of some rows if necessary.
It also may just be the whole sheet, not just a range of cells....
...How to keep the macro running?
Is it possible to include a code to let the macro to run non stop? i
yes, would excel crash if i activate another macro at the same time?
Message posted from http://www.ExcelForum.com
Only one macro can run at a time. If a macro is running, you can't do
anything else with XL.
Take a look at the OnTime function to have a macro repeat at fixed (or
variable) time intervals:
In article <firstname.lastname@example.org>,
hce <<email@example.com>> wrote:
> Hi All
> Is it possible t...Why can't I show or hide rows in an outline on a protected sheet?
I have created an outline on an Excel 2000 Spreadsheet. This is a shared
workbook and I have locked certain cells that I don't want changed. However,
when I protect the worksheet, Excel will not allow me to show or hide the
rows in the outline. When I try, I get a message window that says " You
cannot use this command on a protected sheet" then tells me how to unprotect
the sheet. I need to be able to protect the locked cells from being changed,
but allow showing and hiding of the outlined rows. Is this possible?
AFAIK not possible
Frankfurt, Ger...AutoComplete addressing resets every time I retsrat Outlook. Why?
I love the AutoComplete addressing feature in Outlook but it has changed
since I changed to Outlook 2003. Previously (Outlook XP?) the cache would be
accessed all the time but now everyime I restart Outlook, AutoComplete
addressing cannot access previous entries. Why?
In other words I send a message to Joe.bloggs@ whatever and thereafter if I
just type in 'joe' it displays the full email address for me to simply click
on. Great. However this only lasts as long as my Outlook session: if I
restart Outlook I lose Joe and everyone from the list. This did not happen
with previo...Budget not showing both transactions
I am using Money 2006
I have a life insurance category that has two transactions for October.
Money only shows the total for one.
If I double click on the insurance in the budget report, I see both
The one that is not showing is part of a loan payment for my mortgage life
I tried repairing the file.
Nevermind, I forgot the total amount was shown in the debt.
Money would have calculated it twice if it also showed in the insurance
I am sure that this question has been asked and answered. I am creating a
worksheet for my class. I have a value in cell b2( I want use this value
thru out the sheet). Let say b2 = 10
b c d
3 5 6 8
4 3 7 1
I want to subtract each value from b2(10). How can I do this without doing
On Thu, 1 Apr 2010 14:06:04 -0700, AFL-math
>I am sure that this question has been asked and answered. I am creating a
>worksheet for my class. I have a value in cell b2( I want use...MY OUTBURST# 2 and I am off for a long time, sorry (vacation)!
By the way,
"major trading partner" is an oxymoron, since there's no partner. There's a
flow of money Eastwards, and flow of goods Westwards.
Precisely as was at the onset of World War I. As Germany slowly has lost
its role as the "engine", technocratic center of Europe due to cheaper labor
on British Islands, it lost its leverage. Germany could not take it
anymore. United States may also lose patience one day. It is best to
settle peacefully in a form of Trade Reform.
If they Chiense refuse to set Yen free, stop buying their cheap junk. This
...Missing Toolbar in Outlook
Hi. I would appreciate some help with Outlook. When I
have opened an email message and within the message I
want to "reply" or "reply to all" the buttons are
missing. Something happened that I cannot figure out. I
have gone into Toolbar Command Action and highlighted
these buttons but may not be going in the right direction
as this did not fix the problem.
Your help is appreciated.
Is your cursor in the message body when you try to reply or forward the
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
...Run-Time Error 3070 when using FindFirst
I have two forms, one with summary data and one showing the full
record. I am trying to open the full record, by double clicking on
the summary record.
Both forms use the same record set.
Whe I do a debugm the "me.ConId" gives the right value. The error
says that the that MS Access does not recognise "ContactId" as a valid
ConId is an alais of ContactId and formated as an integer
I have checked the groups for this error, but only found solutions for
text related data. Not sure if it applies to number dat.
The code used is as follows:-
Private Sub ConId_Db...Keeping photos in line
Several questions about moving photos in columns:
I have a two column page, a manuscript of 150 pages, and want photos t
slide with the type as I insert text in previous pages. I use th
format, inline, move with copy instruction. Sometimes it moves th
photo over to the other column.
I want all photos inserted from files to automatically be embedded, o
inline. Is there a command for that?
Is there a better way to do a caption for the photos, what we printer
call a cutline, than use a new text box? I have to in line it too, an
it sometimes wants to move one or two lines when I give the order...When Generating Report don't show columns which are empty
>I have project in MS access.
>In that project I am generating some reports for my company.
>Now In my form I have one combobox(PalletNo_combo)
>when I select an item from combobox and then click on search button then it will generate Report on search criteria.
>Now in that report I have 15-20 fields like
rtons,PartialCartons,ShippedDate,TotalQuantity,Shi ppedQuantity etc
>Now when Report gnerated I have column PartialCarton which is empty sometimes bcz of Null value inside it.
>So I don't want to show it in report...New table field not showing up as a Control Source
How can I get the text box field on my form to populate my new column in my backend table?I went into Design View for my table and added a new field that I want to be populated from my form.When I added the new text box to my form, it showed up as Unbound. I clicked on Properties for that particular text box and went to select the Control Source from the drop down menu - however my new table field did not show up in the drop down.How can I get the text box field on my form to populate my new column in my backend table?Thanks for your help,Matt Is your table the record source of that form? Mo...How do I keep my own formatting for a pivot-chart on refreshing
I have many pivotcharts which need to be continually refreshed to represent
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.
To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.
Can anyone help????
...How do I hide zero values but keep currency format in P.O. form?
I'm creating a purchase order for our company and am having trouble
formatting some cells. I need a currency value in the Total section only if
there is a value in the Quantity and Unit Price section. I formatted the
Total cells to Currency. But if there are no values in Quantity or Unit
Price, zero values appear in the Total cells. How do I format the total cells
to only show price values when there are values in Quantity and Unit Price?
When you format a cell as currency you get a custom format like this
(depending on the otpions you chose)...
Choose the ...Single Weekly Time Sheet
I am having a problem with time sheet reporting. We have a weekly timesheet
which hourly employees complete every week. Most have been saving EACH
timesheet. That is 52 timesheet tabs.
What I am trying to accomplish is this:
Use the time sheet, and have the TOTALS of each column transfer to a single
worksheet. Example of columns in weekly timesheet:
DAte Day of Week Reg OT Sick Vac Total Hours Lunch
The date column is filled with date beginning on a Sunday, ending Saturday.
There are formulas to calculate the total hours.
...enter current time with seconds
Control-Alt-; enters the current time but it does not have a second
information. Is there a setting that it will include the second
CTRL + SHIFT + ; enters the current time.
No, seconds cannot be included.
You need a small macro for that.
ActiveCell.Value = Format(Now(), "h:mm:ss AM/PM")
Gord Dibben MS Excel MVP
On Wed, 13 Jan 2010 06:56:14 -0800 (PST), cpliu <firstname.lastname@example.org>
>Control-Alt-; enters the current time but it does not have a second
>information. Is there a setting tha...Investment summary still shows closed accounts
I know this has been addressed before, and I think I've tried the fixes to no
avail, but I'd like to try again. I've searched the database and can't find
anything on this anymore.
I have accounts that are closed and should have zero balances, but they have
infinitessimal fractions of shares lurking and I can't seem to get rid of
them with "Remove shares," etc. I'm using Money 2006, but I had this problem
even with an older version.
In what ways does "remove shares" fail? More details would help.
"sumpteretc&quo...countif with time
I need to count the number of times there is an entry in column A that is
between 08:00-08:59, 09:00-09:59, 10:00-10:59, etc.
So the sum would be 08:00-08:59 0
> Col A
> I need to count the number of times there is an entry in column A that is
> between 08:00-08:59, 09:00-09:59, 10:00-10:59, etc.
> So the sum would be 08:00-08:59...Calcualte date and time
Please help me how to calculate the number of hours and minutes
Between two columns:
Beginning Apt. Ending Apt.
2/1/10 9:40am and 2/1/10 2:00pm. It will be 4 hours and 20 minutes or
(4:20) if I calculate manually. Please help me to write the formula.
If your beginning time is in A1, and ending time in A2, the formula is:
Format as a time.
"Chi" <Chi@discussions.microsoft.com> wrote in message
> Please help me h...change old Toolbar style
Hi there, I managed to add a toolbar in my dialogbar, but
the buttons in the toolbar are old style push-button ones.
Is there any way to change them into the new style, which
are flat, and do not raise themsleves until mouse-over?
"Scints" <email@example.com> wrote in message
> Hi there, I managed to add a toolbar in my dialogbar, but
> the buttons in the toolbar are old style push-button ones.
> Is there any way to change them into the new style, which
> are flat, and do not raise themsleves ...Combining Worksheets and keeping them separate
I have a workbook that contains two worksheets.
Worksheet one as information such as name, address, etc.
Worksheet two has the same fields/columns of information, however the data
itself is different.
I need to keep these two lists separated, however, I also need to have them
combined at times.
Is it possible to create "Worksheet 3" that will automatically update when I
add/modify records in Worksheet 1 or Worksheet 2?
There is not an easy way to do that.
Instead of three worksheets, use one worksheet (a single database). Then
you have two choices.
1) Enter...Why does portfolio review show N/A for DJIA and S&P500 peformance?
I am evaluating Money 2004, and am using the Portfolio
Review. (Portfolio -> Analyze my portfolio -> Portfolio
When I scroll down to the performance section, I see the
year to date performance of my portfolio and the
performance for the last 12 months.
The performance of the DJIA and S&P500 are also listed
below my portfolio, but instead of a percentage return,
the performance is listed as "N/A".
How can I get the portfolio review to show the performance
of the DJIA and S&P500 to compare to my portfolio?
...Quick Time Entry
I have copied Chip Pearson's code into my Spreadsheet and all seems
well until I enter a time beginning with a zero. Can anyone poinit out
what I'm doing wrong?
If I enter 1500 I get 15:00 which is what I expect
If I enter 0000 for midnight I get an error from the EndMacro, same
thing if I enter 0600
The Cells are formatted to hh:mm
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim TimeStr As String
On Error GoTo EndMacro
If Application.Intersect(Target, Range("B21:C28")) Is Nothing Then
If Target.Cells.Count > 1 Then
End I...Run-time error 80004005
Run-time error -2147467259 (80004005) Could not update; currently
locked by user 'abcde' on machine 'ComputerName'
What is the actual cause of this error?
Here's the situation: I have an app (VB6 of course) in which I'm
maintaining an Access database. The db contains 2 tables. Both tables
are open at all times - with these statements:
Set db = DBEngine.Workspaces(0).OpenDatabase(MDBFileName$)
Set rsEventLog = db.OpenRecordset("EventLog", dbOpenTable)
rsEventLog.Index = "IssueDate...Contacts 'display as' keeps showing email address even when I dele
I'm using Outlook 2007 recently upgraded from Outlook 2003 contacts.
I don't like email addresses showing in emails, so I have always written
'display as' with name only in Contacts. However, Outlook 2007 has added the
email address in 'display as' for everyone. When I go in to delete the email
address, SAVE and Close - and go back to check, nine times out of ten, the
email address is back in there. Very frustrating.
Is this a known problem? Is there a fix? I just want 'display as' to
simply reflect what I put in there - not what Outlook decides...