I am new to VBA and do want to make viewing and printing a selection
of lines in an order sheet easy.
In the order sheet (400 lines of products) customers can indicate what
the want to buy by changing the quantity in column QTY
I want to present them a shortened list for all the products with
Hi Louis,
Can you send the sample file so that I can prepare the macro as per your
sheet.
Regards,
Andy
On Fri, Jul 3, 2009 at 2:46 PM, loconel icefa...@gmail.com wrote:
I am new to VBA and do want to make viewing and printing a selection
of lines in an order sheet easy.
In the order
In General,
Assuming that the range has 5 columns and the Quantity field is in the 5th
Column, you can use the following macro:
Sub PrintSel()
'
' PrintSel Macro
'
' Keyboard Shortcut: Ctrl+Shift+P
'
ActiveSheet.Range($A$1:$E$17).AutoFilter Field:=5, Criteria1:=0, _
Operator:=xlAnd
Hi, Hopoing someone will be kind enough to help me with this simple
query.
I have a spreadhseeet, and want to write some vba code which says if
the value of cell a2 is greater than the value of cell g3, then
display a message saying Value cant be higher than effort
Best
Steve
hi,
try this code -- this example print excel file name in the given
folder
Dim oWbk As Workbook
Dim sFil As String
Dim sPath As String
Dim strDocName as string
sPath = Path \ FolderName
ChDir sPath
sFil = Dir(*.xlsx)
Do While sFil
Set oWbk = Workbooks.Open(sPath \ sFil)
Set
Hi,
Try following:-
=IF(ISBLANK(Sheet1!C6),,Sheet1!C6)
Thanks,
Dilipandey
On 7/2/09, Lynn moley_c...@yahoo.com.au wrote:
I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?
Hi Steve,
Have a look at the attached.
Regards - Dave.
Date: Fri, 3 Jul 2009 02:12:06 -0700
Subject: $$Excel-Macros$$ Simple VBA Data validation query
From: stevedha...@googlemail.com
To: excel-macros@googlegroups.com
Hi, Hopoing someone will be kind enough to help me with this simple
Dear All,
I have an Excl file which is password protected. Unfortunately I forgot the
passward. is there any way to recover the password ?
Kindly suggest,
Thanks and Regards ,
Debashis.
--~--~-~--~~~---~--~~
Dear All,
I have an Exls file containing 9 sheets .. where each sheet are
connected / linked with each other .
Now the question is when a particular link is clicked ,, the cursor
automatically goes to its designated place may it be at the top of the
sheet or bottom of the Sheet or
Hi Andy,
Thank you for your quick response. Your helping a Fair Trade Shop to
promot Christmas
I don't know how to send you the file but you can download it from our
site.
http://apeldoorn.wereldwinkel.nl/index.php?page=vrije_pag_5
and then Download het bestelformulier van onze site. Klik hier
In Excel you can call last action again and again by pressing F4 Key
let supposed you just fill a color in the cell you want other cell to be
fill like that
just go to that cell and press F4 key it will perform that action again
regards
Santosh Bahuguna
On Thu, Jul 2, 2009 at 12:02 PM,
Hello.
You can use :
File2 = Dir(OpenFile_2)
Even if you don’t open the file.
HTH
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de obahor o
Envoyé : jeudi 2 juillet 2009 22:25
À : excel-macros@googlegroups.com
Objet : [Norton
Hi.
Have a look at the attached file. Unfortunately, I use a French copy of
Excel, so the calendar control is too a French one. You'll have to replace
it.
HTH
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-
mac...@googlegroups.com] De la part de Lynn
Hi Michael,
Try following:-
1. Press key combination CTRL + [
2.Press key combination CTRL + Shift + [ which means CTRL + {
both will take you to the Cell A4.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New
Hi Icefagur,
One quick way could be apply autofilter (Select data - press Ctrl + * and
then press Alt + D + F + F). Now select the quantity columen and filter out
the data 0. The data will automatically shortened and if you want to print
it out.. then press ctrl + * and then choose the print
Hi Steve,
Check out the logic in the attached workbook. It is simple, small and
effective. Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Fri, Jul 3, 2009 at 2:42 PM, Steve Douglas P2p, MCP
Hi Lynn,
Calender control has been explained in the attached workbook.
Note:- Date will be inserted in the selected cell, which can be modified.
check up the code and you will understand the logic, It is quite simple.
Thanks,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
OK. Thanks for the input, Dave.
On Jul 3, 1:04 am, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Doug,
All formatting can be done through VBA.
But if you want the formatting applied to each cell as you click on it, then
you need an event macro, which needs to reside in the code
Hi Dilip,
Could you please tell me how you did the calendar thing?
Your sample workbook gives no explanations, and I can't figure it out by the
code.
Regards - Dave.
Date: Sat, 4 Jul 2009 00:22:25 +0530
Subject: $$Excel-Macros$$ Re: calendar pop-up
From: dilipan...@gmail.com
To:
Hi Dave,
explanation:-
First, insert calendar control. (Insert-Object-Calendar Control),
now have that code in the vb editor. If u look at the code, u'll
figure out as to where u want the date to appear.
As i m replying this using my mobile device, detailed explanation is tough.
Thanks,
20 matches
Mail list logo