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 Varian
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;
, "")
NDate = Mid(D2, 3, 3)
'MDDate = take number of days and convert to mm/dd
'Code to rearrange the pieces back together
Else
Dtx.Value = ""
End If
Next
End Sub
Thanks,
Don
On Wednesday, August 7, 20
7;t
found 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 ti
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 wrote
to figure out the code 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 M
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 symbo
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
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
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
A macro is possible but it probably should be based on an advanced filter.
You need to give much more info on what you want.
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
> .-: us
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 Cells(Ro
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
Your solution doesn't really pertain to the question but here is yours
cleaned up
Sub RemoveDataSAS() 'No selections.Fire from Sheet2
Dim mv As String
Dim mf As Range
Dim ma As String
If ActiveSheet.Name <> "Sheet2" Then Exit Sub
mv = Application.InputBox(prompt:="Pick a cell.", Type:=8)
With Sh
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
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 stateme
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 <> Range("c1"
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 sam
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
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 (S
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, i
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 G
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 gene
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 c
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, it's given me #value error, however
>
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
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 r
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 wrote:
> Dear Don,
>
> can you share your workbook with Group.
>
>
>
>
>
> On T
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 wrote:
> Sam, thank you so much . . . the formula works GREAT!!!
>
> Steve
>
> On 8/20/2011 1:05 AM, GoldenLance wrote:
>
>
>
> > Use =INDIRECT(
Tue, Jun 14, 2011 at 8:41 PM, Don 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
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.
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 Ob
o 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 wrote:
> Is it HTTPS:// site?
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:exc
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 t
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 prio
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
To: Hems ; excel-macros@googlegroups.com
Sent: Tuesday, June 23
37 matches
Mail list logo
