In Excel 2003 on Windows 7 I have created a custom toolbar using VBA.
The toolbar has about 7 buttons each of which activates a separate macro.
This is the code I use:-
Sub CreateMenubar()
Dim iCtr As Long
Dim MacNames As Variant
Dim CapNamess As Variant
Dim TipText As
the pieces back together
Else
Dtx.Value =
End If
Next
End Sub
Thanks,
Don
On Wednesday, August 7, 2013 7:20:15 PM UTC-6, Sam Mathai Chacko wrote:
Don, try passing the number of days to the date function like this.
=TEXT(DATE(2013,1,No. Of Days - 1), m\/d
Thanks itware2008,
See my response to Sam above. I forgot to mention one little fact - this is
for VBA!
Don
On Thursday, August 8, 2013 8:51:05 AM UTC-6, itware2008 wrote:
Hello Don,
If I understood you, this function should help you
=DATE(YEAR(TODAY());1;0)+A2
where A2 represents
any solutions yet.
Thanks,
Don
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like
Greetings,
My name is Don Barton and I am a laboratory informaticist at a small
hospital in beautiful Colorado, USA. I've done a lot of work in Access,
but am needing to learn VBA in Excel. Look forward to interacting with you
all.
Don
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Greetings,
We have a scanner we use to scan a barcode for blood units for a hospital
into an Excel spreadsheet. The scanner reads the entire barcode, but we
want to remove 00 at the end of the scanned string. If there isn't 00
at the end, make it null cell. We are using the correct
for the = at
the beginning. An actual scanned example is: =W05631300409200. If the
column is formatted as text, the = is retained in the string, otherwise,
Excel will try to do something with it, and it isn't understood.
Thanks,
Don
On Mon, Jul 29, 2013 at 11:46 AM, Sam Mathai Chacko samde...@gmail.comwrote
vba, thanks for your suggestion, which will work fine in formula.
De Premor - the code works exactly as designed with our barcode scanner!
Our Blood Bank supervisor is impressed!
Thanks you so much for your quick reply and expert help.
Don
On Mon, Jul 29, 2013 at 12:37 PM, De Premor d
OK
Option Explicit
Sub getallSAS()
Dim i As Long
Dim dlr As Long
Dim cr As Double
Dim slr As Long
Sheets(all up).Select
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
Columns.ColumnWidth = 2
Rows.RowHeight = 4
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i)
agree!!!
On Monday, October 29, 2012 11:36:55 PM UTC-5, David Grugeon wrote:
I am not going to spend my time downloading your file untill I know what
it is you want. Please do us the courtesy of copying the steps from the
file and putting them in your post.
Also put a more relevant
Why not make your life easier and use ONE sheet for all wtih an extra
column for the name and then use filter to see the individuals as
desired
On Monday, October 29, 2012 6:22:14 AM UTC-5, Pooja S wrote:
Hi Team,
Attached is the sheet where in i need some formula to get the below
Should do it in .xlsM workbook.
Sub getallSAS()
Dim i As Long
Dim cr As Double
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i)
cr = Application.Match(contact, .Columns(1), 0)
.UsedRange.Offset(cr).Copy
You would want to use some autofilter or advanced filter with a series of
input boxes or a user form.
On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote:
Dear all
I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
.-: user want to find details of
Always show a before/after and the logic
On Thursday, October 4, 2012 1:33:22 AM UTC-5, Vishwanath wrote:
Need help
Dear All,
I need your help in automatic some calculations in spreadsheet.
I have data in excel as below;
It consists of 2 parts. first part is Expense statement and
First. A worksheet event macro must be in the SHEET module (or ThisWorkbook
for all shts). Try this simpler approach using all vba .
'===
option explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim mf As Range
If Target.Column 1 Then Exit Sub
'If Target.Address
Provide a file with this to dguillett1 @gmail.com
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
Dear All
Can Any one help me to write a macro for following things.
In sheet 1 I have more than 200 items.I want to make a sample by choosing
items from this list.
1.I will
I have re read your post several times and looked at your file and I have
NO idea what you want.
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
Dear All
Can Any one help me to write a macro for following things.
In sheet 1 I have more than 200 items.I want to make a sample
Methinks you are making this much more difficult than necessary.
Either fully explain what you want with before/after example
If all else fails, send file to dguillett1 @gmail.com
On Tuesday, October 2, 2012 4:33:57 PM UTC-5, Diamond Dave wrote:
Attached is a file which contains a Macro
I LOOKED at the provided file and gave proper
answers
including the homework question about sumproduct.
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
Dear Group,
When I mannualy enter the C7 into the following formula, it has
what is wrong with what I posted much earlier
INDEX(C:C,MATCH($H12,$H:$H))
instead of this
=INDEX(C2,MATCH($H12,$H$2:$H$9,0))
if you insist on sumproduct, this will do just fine.
=SUMPRODUCT(($H$2:$H$9=$H12)*C$2:C$9)
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
Dear
What you want is easy to do but I fail to see the LOGIC of what you want.
Explain...
On Friday, September 28, 2012 5:48:22 AM UTC-5, shrini wrote:
Dear All
Can Any one help me to write a macro for following things.
In sheet 1 I have more than 200 items.I want to make a sample by
Why bother when I gave you the PROPER formula.
On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote:
Dear Group,
When I mannualy enter the C7 into the following formula, it has no
problem,
=SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*))
but when I am trying to generate C7,
I don't quite understand your need. Please explain excluded. give examples
On Friday, September 21, 2012 10:37:34 AM UTC-5, rekha siri wrote:
hi experts,
please help me in this concern, i have data spread from A to AB columns
from one of the column i want to apply filter select one region
Your sample does not result in a hit in col M for roy or rod.
On Friday, September 21, 2012 10:37:34 AM UTC-5, rekha siri wrote:
hi experts,
please help me in this concern, i have data spread from A to AB columns
from one of the column i want to apply filter select one region in column
e
How would I do that? I do not see a way to attach it to this post and
unfortunately it is not on a web-server only an internal secured data
server.
Don
On Oct 25, 2:30 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Don,
can you share your workbook with Group.
On Tue, Oct 25
numbers?
Don
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3
You can use this part of the formula for the simple vlookup
COLUMN'=MATCH(TEXT($J$3,MM/yy),'2011 Actual'!$A$1:$X$1,0)
On Aug 20, 6:43 am, Steve Weaver steveweave...@comcast.net wrote:
Sam, thank you so much . . . the formula works GREAT!!!
Steve
On 8/20/2011 1:05 AM, GoldenLance wrote:
Hi,
I know this can be done because I've seen it before. I have to login
to a web-site and query some data. I have the code to get me to the
web page but I have to login. I know there is a way to write into the
macro to fill in the needed info and login.
Any assitance is greatly appreciated.
14, 2011 at 8:41 PM, Don donf...@gmail.com wrote:
Hi,
I know this can be done because I've seen it before. I have to login
to a web-site and query some data. I have the code to get me to the
web page but I have to login. I know there is a way to write into the
macro to fill in the needed
H,
I tried the code and got a VB run-time error.
Run-time error '424';
Object required
There error highlights the yellow line below.
Here is the code as I have it installed.
' TEST Macro
' Macro recorded 6/10/2011 by Don Flak
'
'
Dim ie As Object
Set ie = CreateObject
to the
page and the report I need, I simply can't get over the last hurdle and
click the export button.
Thanks,
Don
On Sat, Jun 11, 2011 at 12:53 AM, Rajan_Verma rajanverma1...@gmail.comwrote:
Is it HTTPS:// site?
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros
I have to log onto our corporate reporting portal, click through
several folders, execute data queries, export the data to a .csv file
and then run some reports from that data.
I have the code written to get to the the web-apge I need, and
prepare
the report for exporting.
There is a button at
I don't know if this is possible but I am hoping so. I run several
performance reports daily and weekly. On Monday's I have to run the
reports twice, once to compile the prior week recap and the second
time to produce the current weeks performance. Currently between runs,
I have to archive the
Hems
I have aquestion on how to use your form.
I am just learing Excel. I made your form come up once from your sheet but I
can not make it come up again.
Thank you.
Don
From: Harmeet Singh harmeet.hew...@gmail.com
To: Hems coolh...@gmail.com; excel-macros
34 matches
Mail list logo