if you have doubt let me know.
>
> Regards,
> Ganesh N
>
> On Wed, Sep 24, 2014 at 1:07 PM, Shankar Bheema
> wrote:
>
>> Dear Ganesh
>>
>> I have tried just now and what I found is, when I enter rest of column
>> fields from the Form Entry and pressing th
.
Please provide solution.
On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N wrote:
> Hi Shankar,
>
> PFA,
>
> I have just added one more button (Modify) use that before update button.
>
> Thanks & Regards,
> Ganesh N
>
> On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bheema
>
thank you very much bro
On Wed, Sep 24, 2014 at 12:26 PM, Ganesh N wrote:
> Hi Shankar,
>
> PFA,
>
> I have just added one more button (Modify) use that before update button.
>
> Thanks & Regards,
> Ganesh N
>
> On Wed, Sep 24, 2014 at 11:00 AM, Shankar Bhee
Good morning all,
I am attaching an excel workbook which is meant for office file tracking.
On the worksheet I placed commandbutton namely Entry Form. Which enables
entry of the data into the sheet.
Entry fields will be initially filled upto TIMEIN column.
>From the Timeout, entry of columns wi
hai Vaibhavji
thank you so much
regards
shankar sb
On Thu, Aug 7, 2014 at 12:03 PM, Vaibhav Joshi wrote:
> Hi
>
> PFA
>
> Cheers!!
>
>
> On Thu, Aug 7, 2014 at 11:21 AM, Shankar Bheema
> wrote:
>
>> Hai friends
>>
>> I am attachin
Hai friends
I am attaching an Excel workbook for an apartment maintenance.
sheet1 i considered as Main page,
sheet2, sheet3 will hold individual accounts and their balances
when the extract balances button pressed on the sheet1 page, the names of
the remaining worksheets should come
I am attaching the html page and excel workbook. I need help from the
members that the data entered into the html page shall be generated the
excel sheet after pressing the button on webpage.
Kindly guide me in this regard.
regards
shankar sb
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hai Friends
Pleas guide me and refer any site which is having sample EXCEL VBA
applications in the retail banking sector.
I am very thankful to one and all.
regards
shankar sb
--
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 Face
>
>
> On Tue, Feb 11, 2014 at 2:36 PM, Shankar Bheema wrote:
>
>> dear all
>>
>> I am attaching the workbook. I tried with the solution provided for
>> getting days between two dates by the respected programmers for my query
>> kept in yesterday. But I am n
Dear all,
I attached an excel workbook which contains 3 worksheets. worksheet1 is
named as Members worksheet2 is with membername and worksheet 3 is also
named after the member
how can obtain When the member worksheet is filled the corresponding
membernamed worksheet also filled.
how to obtain th
Thank you ravinder.
On Mon, Jan 20, 2014 at 4:43 PM, Ravinder wrote:
> It depends on system memory there is no limit of worksheets
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema
> *Sent:* Monday, Jan
Hai everyone
I heard that an excel workbook can manage only 255 worksheets. Is it
true. Cant it be increased ?
regards
shankar sb
--
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.facebo
thank u deepak its working
On Sat, Jul 27, 2013 at 12:09 AM, Deepak Barnwal wrote:
> PFA
>
> Regards
>
> deepak
>
>
> On Fri, Jul 26, 2013 at 11:28 PM, vba wrote:
>
>> PFA
>>
>> Actually years should be 37 & not 36!!
>>
>> HTH//Che
t; the other two?
>
>
> On Mon, Jul 22, 2013 at 12:20 PM, Shankar Bheema
> wrote:
>
>> Hai everyone
>>
>> I attached an excel sheet which contains a form. In that I placed three
>> nos. of combo boxes. Each have its values.
>>
>> when I
Hai everyone
I attached an excel sheet which contains a form. In that I placed three
nos. of combo boxes. Each have its values.
when I change the gp combo value the remaining two combo values should
automatically change.
I tried in many ways but failed.
please help me out.
regards
shankar sb
Dear Friends
Yesterday I posted the same file in the group. Today some more fields I
had added to the file. Kindly provide solution to the attachment. I am
very thankful to the group.
regards
shankar sb
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FO
Dear Friends
I have doubts in projecting the interest amount on the attached worksheet.
Kindly provide solution. I am very thankful to the group.
regards
shankar sb
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thre
thank you santhosh
On Thu, Mar 29, 2012 at 12:27 PM, Shankar Bheema wrote:
> Dear experts
>
> I am using to take a printout of an userform by using the following code
> in a command button:
>
> me.printform
>
> But, is there any option to take a softcopy of an unse
Dear experts
I am using to take a printout of an userform by using the following code in
a command button:
me.printform
But, is there any option to take a softcopy of an unserform in a .pdf
format ?
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise,
-- Forwarded message --
From: Shankar Bheema
Date: Sat, Mar 24, 2012 at 11:00 AM
Subject: $$Excel-Macros$$ Service Count problem
To: excel-macros@googlegroups.com
Dear Experts
In the userform of the attached workbook contains Date of Joining text box
and Date of Retirement
nks with
>>
>>
>>
>> Mothilal.J
>>
>>
>> On Tue, Mar 27, 2012 at 12:54 PM, NOORAIN ANSARI <
>> noorain.ans...@gmail.com> wrote:
>>
>>> Dear Shankar,
>>>
>>> You can also use..
>>>
>>> Sub Print
-- Forwarded message --
From: Shankar Bheema
Date: Sat, Mar 24, 2012 at 11:00 AM
Subject: $$Excel-Macros$$ Service Count problem
To: excel-macros@googlegroups.com
Dear Experts
In the userform of the attached workbook contains Date of Joining text box
and Date of Retirement
Dear experts
How to get watermark impression on the userform while taking printout ?
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, an
Dear experts
for a command button of an userform for Printing of sheets purpose I am
using code as
sheets("sheet1").printout
whereas, i need to print 3rd page of sheet1 everytime, so what change is
required in the above code to get only 3rd page.
regards
shankar sb
--
FORUM RULES (986+ membe
Dear Owner of the Community
Recently posting query by an attachment was failed due to size of the
file. The returned comments by the server is that the blog is not
accepting more than .10 mb capacity. Please increase the size to enable
posting with an attachment.
regards
shankar sb
--
FORUM R
Dear Experts
In the userform of the enclosed excel workbook, there exists two textboxes
for date format. Is it possible to get a background impression like
DD-MM- in a grayscale for the convenience of the users of the
application. That impression would disappear when user types a value for
t
Dear Experts
In the userform of the attached workbook contains Date of Joining text box
and Date of Retirement textbox. The difference of both the values should
come to
23 yrs 01 mth 29 days but it is showing as 23 yrs 01 mth 01 day
In my office procedure resultant date should be given 1 bonus
On Thu, Mar 22, 2012 at 4:23 PM, Shankar Bheema wrote:
> Dear Experts
>
> I attached an excel workbook. I made my office related form design on
> sheet1 of the work book. If the similar form of different kind placed in
> sheet2, and if I supply data to the userform relating to
Dear Experts
If a pdf file name is placed on a Label form and assume its location is in
D:/. How it would be hyperlinked from the USerform.
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Hel
; Noorain Ansari
> *http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>
>
> On Tue, Mar 20, 2012 at 11:32 AM, Shankar Bheema
> wrote:
>
>> Dear experts
>>
>> I have attached an excel file containing data of
gt;> --
>> Thanks & regards,
>> Noorain Ansari
>> *http://noorainansari.com/*
>> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
>>
>>
>> On Tue, Mar 20, 2012 at 11:32 AM, Shankar Bheema
>> wrote:
>>
what data do you want from the data file and where do you want it?
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Shankar Bheema
> *Sent:* Monday, March 19, 2012 11:51 PM
> *To:* excel-macros@googlegroups.com
> *Subj
Dear experts
I have attached an excel file containing data of qualification. On the
userform I created check boxes with similar to the datasheet data.
I need action like, only the tickmarked check box data only shown on the
data sheet all other have to go in hidden mode (even in print also).
wa
I tried the following code and during execution the following error is
coming.
run time error 9,
Subscript out of range.
Pls provide solution.
regards
shankar sb
On Wed, Feb 29, 2012 at 4:28 PM, Shankar Bheema wrote:
> thank you abhishek
>
>
> On Wed, Feb 29, 2012 at 12:11 PM, A
Dear Experts
The above attached file contains an userform for rounding off of the value
if the 3% of the given value comes to more than multiple of 10 except the
fraction that value should be rounded off to the nearest multiple of 10
ex. if the value of 3% comes to 660.01 or 660.50 or 660.99 th
thank you
On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI wrote:
> http://www.mrexcel.com/forum/showthread.php?t=354
>
> On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
>
>> is it possible to save a particular worksheet of a workbook with a save
>> comma
is it possible to save a particular worksheet of a workbook with a save
command button on an userform ?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
thank you for solution
On Tue, Feb 21, 2012 at 3:24 PM, Prajakt Pande wrote:
> Dear shankar,
>
> I tried to solve your problem
>
> PFA
>
> On Tue, Feb 21, 2012 at 12:47 PM, Shankar Bheema
> wrote:
>
>> Dear Experts
>>
>> I am enclosing the attach
Dear Experts
I am enclosing the attachment which was solved by NOORAIN. but when I add
third textbox to the userform, the code is not working. Please guide me.
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread tit
ox1.SetFocus
> Else
> TextBox2.SetFocus
> End If
> End Sub
>
> See attached sheet.
>
>
>
> On Fri, Feb 17, 2012 at 1:18 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> I am attaching an userform with 2 textboxes. While on exit from the firs
Dear Experts
I am attaching an userform with 2 textboxes. While on exit from the first
textbox I have given a msgbox alert for not keeping the box empty. But the
setfocus event is not working for it. Kindly guide me.
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation
with
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* Shankar Bheema
> *Sent:* Sunday, February 05, 2012 10:50 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ refreshing data of sheet2
>
> Dear experts.
>
> I attached
Dear Experts,
I placed two userforms for a worksheet.
txtavgfrom1 of userform2 should carry the next day of the previous 10
months date of txtdor.text of userform 1
eg. if txtdor.text is 30-04-2041 then txtavgfrom1 of userform2 should carry
01-07-2040.
If the dateavgfrom1 of userform2 not starts
Dear experts.
I attached an excel worksheet and want to refresh data of sheet2. Pls
specify the code.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and
Dear Sam
Please provide solution.
-- Forwarded message --
From: Shankar Bheema
Date: Tue, Jan 31, 2012 at 12:17 PM
Subject: Re: single active cell space between words
To: Sam Mathai Chacko
Good afternoon Sam,
Yes, exactly.
regards
shankar sb
On Mon, Jan 30, 2012 at 11:35
t;> End Sub****
>>
>>
>> Private Sub TextBox2_Change()
>>If Len(TextBox2) = 2 Then
>> TextBox3.SetFocus
>>End If
>> End Sub
>>
>> On Sat, Jan 28, 2012 at 10:36 AM, Shankar Bheema
>> wrote:
>>
>> Dear Experts
, Rajan_Verma wrote:
> WorksheetFunction.Text(1,””) = 0001
>
> ** **
>
> ** **
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema
> *Sent:* Jan/Mon/2012 11:32
>
> *To:* excel-macros@googleg
culating your date
> difference, but VBA has a function called DateDiff for that purpose. Check
> VBA Help for more info.
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema
> *Se
hod, form and ActiveX controls have that in
> Excel.
>
> If you mean a GotFocus event, ActiveX controls have that and you can use
> them in Excel.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macro
Dear Experts
In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not
provided. Is there any alternative for it in excel vba ?
regards
shankar sb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Plea
thank you noorain bhai
On Fri, Jan 27, 2012 at 2:59 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> Please see attached sheet and use code format for your coding.
>
>
> On Fri, Jan 27, 2012 at 2:23 PM, Shankar Bheema wrote:
>
>> Dear experts
>>
>> I attached
t; Range("H40") = .txtda
> End With
>
> With Sheet2
> Sheet1.Range("F4").Value = .txtpay
> Sheet1.Range("G22").Value = .txtpay
> Sheet1.Range("G27").Value = .txtpay
>
> End With
> End With
> End Sub
>
> End Sub
>
> Rega
> 1) = strNewLine Then
> lngRows = lngRows + 1
> lngCols = Empty
> Else
> rngCells(lngRows, lngCols).Value = Mid(strText,
> lngCounter, 1)
> End If
> NextLine:
> Next
> Next
>
>
Pls provide solution for this problem.
-- Forwarded message --
From: Shankar Bheema
Date: Mon, Jan 23, 2012 at 1:28 PM
Subject: Saving the form data charaterwise in excel sheet
To: excel-macros@googlegroups.com
Dear Experts
I attached a VBA form. How to save the data in
;> .Range("H29")=.GP
>> .Range("B40")=.Pay
>> .Range("E40")=.GP
>> .Range("H40")=.Da
>> End with
>>
>> With Sheet2
>> Sheet1.Range("F4").value=.Pay
>> Sheet1.Range("G22").value=.Pay
>> Sheet1.Range
xt = ""
> End Sub
>
> Regards,
> Sam Mathai Chacko
>
> On Mon, Jan 23, 2012 at 7:14 PM, dguillett1 wrote:
> > Without looking too close, try /30
> >
> > Don Guillett
> > SalesAid Software
> > dguille...@gmail.com
> >
> > From: Shankar
ed sheet.
>
> -
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
> On Mon, Jan 23, 2012 at 1:45 PM, Shankar
thank you very much.
On Mon, Jan 23, 2012 at 6:16 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> See attached sheet...Hope your query has been solved.
>
>
> On Mon, Jan 23, 2012 at 1:36 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> In an excel book, each
Dear Experts
In an excel book, each sheet is named with the designation of the employee
and that particular sheet contains the names of that particular designation.
I placed two combo boxes on the userform, how to link the corresponding
data into the comboboxes with an option that choosing a desi
Dear Experts
I attached a VBA form. How to save the data in charaterwise entered in that
form into the excel sheet ?
regards
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Prob
>lngActualDays = lngDays - Day(DateSerial(Year(TextBox2.Value),
> Month(TextBox2.Value), Day(TextBox2.Value))) + 1
>TextBox3.Value = TextBox1.Value * lngActualDays / lngDays
>If Err.Number Then TextBox3.Text = ""
>
> End Sub
>
> On Sat, Jan 21, 2012 at 11:23 AM,
Dear Experts
I am attaching an excel form, in which according to the promotion date text
box the proportionate pay text box has to show in the command button event
the pay of that particular month according to the days calculation.
eg. if the pay is 1000/- pm (consider every calendar month shoul
Subject: reply regardingrounding off
Kind Attention: Paul Schreiner
thank you for your reply and sorry for my late response as I am out of town.
What I required is:
if a result comes to 20.60 or 20.10 (here whatever be the fraction)
it should be rounded off to 20 only
if a result comes to 21
Dear Experts
Pls provide code line for a command button to invoke Print Dialogue box.
thank you
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
gt; excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema
> *Sent:* Jan/Thu/2012 12:31
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ doubt with rounding off and change event in
> excel vba
>
> ** **
>
> Dear Experts
>
> I am attaching a
Dear experts
I am using excel vba. I want to round off an amount to its nearest
multiple of 10.
eg : 251.10 (here fraction should not be considered only the whole number
which has to be rounded off to its nearest multiple of 10 i.e. 260)
252 = 260
but 250 remains 250
Pls do reply
--
FORUM
Dear Experts
I am attaching an excel vba file. In which I am facing a problem with
change event.
the addition of textbox2.text + textbox3.text values with the value of 3%
of the value of the above both. That 3% value if exceeds 1 rupee it should
be rounded off to the next nearest 10 rs.
eg: i
thank you very much swapnil for posting solution for my query
On Sun, Dec 25, 2011 at 1:09 PM, Swapnil Palande <
palande.swapni...@gmail.com> wrote:
> Hi,
>
> pls find attached file.
>
> Regards,
>
> Swapnil.
>
>
> On Sun, Dec 25, 2011 at 12:26 PM, Shan
dingly
>
> Thanks and Regards,
>
> Somnath C Pardeshi
>
> ----------
> *From:* Shankar Bheema
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, 23 December 2011 11:53 AM
>
> *Subject:* $$Excel-Macros$$ accessing files through form
>
>
>
world.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Fri, Dec 16, 2011 at 1:26 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> I am attaching the .mdb file. which contains combobox an
s,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Dec 15, 2011 at 7:13 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> How to restr
Dear Experts
How to restrict character size for a textbox control for MS ACCESS 2003.
THANK YOU
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need A
Dear Experts
For example, One folder contains some pdf files. Folder is named as "file
number"
If I supplied the particular file number to a textbox created in EXCEL VBA
Form and after clicking OK command button, the list of pdf's in a folder to
be opened in a separate list with the hyperlink fa
Dear Experts
How to assign max length for a textbox control in MSAccess 2003. In
properties, no such facility is available. How can it be assigned through
Code.
regards
shankar sb
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread t
nth1 = ttotmths
> month2 = txtnonmths
> day1 = ttotdays
> day2 = txtnondays
> If year1 > year2 And month1 > month2 And day1 > day2 Then
> yearresult = year1 - year2
> monthresult = month1 - month2
> dayresult = day1 - day2
> End If
> txtnetyrs = yearresult
> txt
Dear Experts
How to assign max length for a textbox control in MSAccess 2003. In
properties, no such facility is available. How can it be assigned through
Code.
regards
shankar sb
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread t
noorain bhai attachment is not accepting by the domain
On Mon, Dec 12, 2011 at 8:47 PM, NOORAIN ANSARI wrote:
> Dear Shankar,
>
> Attachment is missing.
>
> On Mon, Dec 12, 2011 at 8:31 PM, Shankar Bheema wrote:
>
>>
>> Dear Experts Good Morning
>>
>> I
Dear Experts Good Morning
I am attaching an excel vba form. In which I placed a label, textbox and a
command button. *When we supply a file number, it should open all the
related PDF documents kept in a folder in a list box with hyperlinks to
enable us to show the contents in pdf format.* Each
Dear experts Good morning,
I am trying to assign a FIXED TEXT for a TEXTBOX1 Control in MSACCESS 2003.
I have given a code line like:
text1.text="Good Morning"
But it is not assigning the text given in strings. Pls suggest me how to
assign a fixed text to a text box control.
Thank you.
--
thank you very much Kishan
On Thu, Dec 8, 2011 at 11:37 AM, Kishan Reddy, K <
kishanreddy.kethire...@gmail.com> wrote:
> Please add the following code.
>
> rst.update
>
> after assigning values to the fields
>
> Also instead of using rst.fields(0), --- you can use
> rst.fields("fileno") which wi
Dear Sam
How to restrict max length of characters in a text box for MS ACCESS 2003 ?
On Mon, Nov 21, 2011 at 9:57 PM, Sam Mathai Chacko wrote:
> I don't see any remaining doubts! What doubts do you have?
>
> Sam
>
>
> On Mon, Nov 21, 2011 at 10:57 AM, Shankar Bheema
>
your first column has a data type of Number. However, the txtfileno
> variable contains a string / text value. That will have to be corrected
> also. I have fixed this in the attached database.
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sat, Nov 19, 2011 at 4:32 PM, Shankar B
Dear All,
How to restrict character entry in textbox of MSaccess.
The design which is made in MSAccess 2003 is running in 2007 ? How to run
it ?
shankar sb
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Good morning experts !! waiting for your valuable suggetions
On Mon, Nov 7, 2011 at 4:49 PM, Shankar Bheema wrote:
> I am presenting my excel VBA form below and also as an attachment of the
> screenshot.
>
> http://i40.tinypic.com/wa3ekl.jpg
>
> With the help of all of this f
Hai All,
I created a calculation form in EXCEL 2003 VBA. I placed save, update and
etc commands on the VBA form. The data which I enter will save in excel
format. Is it possible to prepare reports using MSACCESS 2003 for
generating reports using the stored data in excel ?
--
FORUM RULES (925+
and Set password with
> Checked Lock Project for viewing.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
>
Hai all.
My query relates to MS ACCESS. Friends, how to make the MSACCESS designed
form application an executable one. means how to hide code part. Because I
made a form and want to give other users in my office. If anything went
wrong my effort will goes to waste. So, I want to hide the code p
thank you for responce
On Mon, Sep 19, 2011 at 7:45 PM, rajan verma wrote:
> You can try visual studio , by excel its not possible
>
> On 19/09/2011, Sam Mathai Chacko wrote:
> > No
> >
> > On Mon, Sep 19, 2011 at 7:14 AM, Shankar Bheema
> > wrote:
> >
Dear All
May I get any expert attention for my problem with regard to the crystal
report and excel vba userform. How to open a designed crystal report from
the excel vba userform by a command button ?
What I have to select from the check boxes in the reference option of Tools
Menu of Excel vBA u
Pls do reply experts..
On Fri, Sep 16, 2011 at 10:16 PM, Shankar Bheema wrote:
> where do i get help for Crystal reports 9 problems ?
>
> --
>
> --
> Some important links for excel users:
> 1.
;
> End Sub
>
>
> Private Sub UserForm_Initialize()
>
> ComboBox9.List = Array("1800", "1900", "2400", "2800", "4200", "4600",
> "4800", "5400", "6600", "7600", "8700
ot;m", CDate(TextBox2.Text)) -
> VBA.DatePart("m", CDate(TextBox1.Text))
> End Sub
> *
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<htt
Pls explain the usage of Dateserial function ? if possible provide me
example
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join
hai all,
I am attaching my excel sheet userform. I am getting wrong result of months
in different way.
for example :
Actual months difference between 01-02-2011 and 30-06-2011 are 5 months but
the result coming as 4
pls provide solution
--
-
://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/>
>
> On Thu, Sep 15, 2011 at 6:01 PM, Shankar Bheema wrote:
>
>> I am attaching the example file. userform1 contains A a
I am having excel data and designed a form using EXCEL VBA. each record of
the excel is represented with a number. I will call the data onto the
userform using the particular number. When I connected the excel data to my
crystal reports 9, all the records are coming onto the report form. But I
w
I am using crystal report 9 to make reports from excel data. How to access
the report from the userform command button ?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I am attaching the example file. userform1 contains A and B textboxes. B
value should get from the other form.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://
How to access crystal report form with VBA ???
--
--
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.
I used the following code to connect the report sheet
Dim rep As New CrystalReport
rep.ReportFileName = "f:\test"
CRViewer1.ReportSource = rep
CRViewer1.ViewReport
End Sub
But its throwing error as "USER DEFINED TYPE NOT DEFINED"
--
-
1 - 100 of 137 matches
Mail list logo
