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,
DILipand
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: excel-macros@goo
OK. Thanks for the input, Dave.
On Jul 3, 1:04 am, Dave Bonallack 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 window of that
> sheet.
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
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 <
steved
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 co
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 De
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
> E
Hi Kunal,
« FileSearch » is no longer supported with Excel 2007. There are free addins
on the net to replace it.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de kunal
Envoyé : vendredi 3 juillet 2009 11:17
À : excel-macros@goog
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 Ant
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, Rachn
How can I have a calendar pop-up box for me to make date selection
when I click on a cell?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Vide
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
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 lef
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.
--~--~-~--~~~---~--~~
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 si
Hi,
Try following:-
=IF(ISBLANK(Sheet1!C6),"",Sheet1!C6)
Thanks,
Dilipandey
On 7/2/09, Lynn 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?
>
> thanks
>
> >
Hi,
I found something but it gave an error while running in excel 2007 but is
working perfectly in xl2003 version
Error came at:
With Application.FileSearch
the error mgs was 'Runtime error:445, Object doesn't support this action
Can any one modify so that it would work on 2007 version of excel
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 & "\" &
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
--~--~-~-
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:=xlAn
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 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 sheet (400 lines o
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
qua
23 matches
Mail list logo
