In that case you will need to as many copy of codes
+
*I did not do this for you. God is here working through me for you.*
On Thu, Sep 25, 2014 at 11:29 AM, Mr_Bill wrote:
>
> It requires a bit more than that. I change TextBox1 to wtBox1 now what
> about wtBox2,wtBox3,wtBox4,wtBox5 as I s
It requires a bit more than that. I change TextBox1 to wtBox1 now what
about wtBox2,wtBox3,wtBox4,wtBox5 as I said there are 15 not just one.
Suppose too much work for a freebie thank you anyways.
On Wednesday, September 24, 2014 10:31:21 PM UTC-7, Vabz wrote:
>
> hi
>
> You need to change TextB
hi
You need to change TextBox1 to text box you desired.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Sep 24, 2014 at 11:18 PM, Mr_Bill wrote:
> Can this code be adapted to work with only certain textboxs? I have 15
> boxes in a form that require
Respected Sir ,
I think i have not properly explain you.
I want when we used filter then full column colour change & not raw colour.
So if i used filter in two or more colu at a time then i get it fast where
i have used filter..
On Thu, Sep 25, 2014 at 9:42 AM, Ashish Kumar
wrote:
> Hi,
>
> P
Hi,
PFA!!
Sort and filter your data from (Row). {3.00}, {4.00}, {5.00} .!!
Regards
Ashish
--
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 RULE
Hi,
Use custom sort function for this.
Regards
Ashish
--
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. Poo
Respected Excel Guru / Friends
I think many of our friend is facing this problem When ever we use filter
column then the colour of small box sign changes
But we have to see properly that where ever filter is there ..
I have 10 entries in excel files from Raw 3 to Raw 12 --- Column From B to
T .
Hi all,
Required is SQL codes for the below data and results
Cust_IDProd_RangeA1P1A1P2A1P3A2P4A2P5Required result is A1P1/P2/P3A2P4/P5
Please help its bit urgent
--
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 th
Can this code be adapted to work with only certain textboxs? I have 15
boxes in a form that require a number to be input and all are named wtBox1
- wtBox15
Dim LastPosition As Long
>
> Private Sub TextBox1_Change()
> Static LastText As String
> Static SecondTime As Boolean
> If Not Secon
call me
On 24 September 2014 21:35, Amit Desai (MERU)
wrote:
> Dear Ashish,
>
>
>
> Thanks a lot for your help...however request you to please explain me how
> you did this?
>
>
>
> Regards,
>
> *Amit Desai*
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On
Dear Ashish,
Thanks a lot for your help...however request you to please explain me how you
did this?
Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Ashish Kumar
Sent: Wednesday, September 24, 2014 8:11 PM
To: excel-macros@googlegroups
Hi,
Check this!!
Final shot from my side.
Regards
Ashish
--
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 titl
Dear Ashish,
Thanks a lot for your help...this one is very closed to what we needed...
Need to make some alteration;
1) We will need if Say bar for A is of 10 mm large, bar for B should be
say 6 mm (& inside the A bar) & bar for C should be say 3-4 mm (& inside the B
bar).
2) What I
Hi,
Check this one!
Regards
Ashish
--
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,
Hi,
Check this..!!
Regards
Ashish
--
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, lik
This is what I did (with my limited knowledge)
It gives me Object Required error but not highlighting any particular row
Runtime Error 424
Would you correct me please?
Sub Transpose()
Dim wk As Workbook
Dim ws As Worksheet
Dim ex As Workbook
Dim es As Worksheet
Dim k As String
Set wk = ThisWorkbo
hi
when you want to move data to compile sheet?
when you save & close data or any other trigger?
+
*I did not do this for you. God is here working through me for you.*
On Wed, Sep 24, 2014 at 2:26 PM, 'Ankit Chandna' via MS EXCEL AND VBA
MACROS wrote:
> Hi,
>
> I want to record the macro'
update macro
Sub test1()
Dim lastrow As Long, xTitleID, I As Long
Dim workrng As Range
Set workrng = Application.Selection
Set workrng = Application.InputBox("Range", xTitleID, workrng.Address,
Type:=8)
lastrow = Cells(65536, workrng.Column + 1).End(xlUp).Row + 1
For
Its really cool!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Sep 24, 2014 at 1:20 PM, Ganesh N wrote:
> Dear Shankar,
>
> The modify will choose the particular row (enter the sn. no) and then wht
> ever change u want make (e.g out time) and then click the
Hi Amit,
PFA..!!!
Regards
Ashish Kumar
On 24 September 2014 16:22, Amit Desai (MERU)
wrote:
> Dear All,
>
>
>
> I would like to have a layered chart for 3 cities...So for each city there
> should be 3 main bars. These each Bar has to have 2 sub bars in side it...
>
>
>
> So for Mumb
You need to bring the lastrow=lastrow+1 into the IF statement, this seems
to work
Sub test()
Dim cell As Range
Dim lastrow As Long, xTitleID, I As Long
lastrow = Range("b65536").End(xlUp).Row
Dim workrng As Range
Set workrng = Application.Selection
Set workrng = Application
i have a question that i have a list of entries with duplicates what i want
is how to get the distnict values(values which occur only one time) .
Please read my question carefully, I am not asking for removing duplicates
what I want is how to get the list of data which occured 1 time only in t
Dear All,
I would like to have a layered chart for 3 cities...So for each city there
should be 3 main bars. These each Bar has to have 2 sub bars in side it...
So for Mumbai - we will have first Bar will be for 5, 2nd sub bar should be
within the first bar & of 5500 & 3rd sub bar should be
Hi Dear.
You can self change of range that which range u want and remove the come
workbook.save /close. And create one new modul anf paste that code.
Thanks
P
Pramod
On 24 Sep 2014 14:38, "prkhan56" wrote:
> Hi Pramod
> Thanks for your response.
> If you check my Input data sheet on File 1 o
Hi Pramod
Thanks for your response.
If you check my Input data sheet on File 1 of my original post. I want it
to paste transposed data it in B9, C9, D9 and E9 downwards.
Second, please assign a shortcut or Button to the macro as clicking on the
Cell is bit risky...it paste the data again and ag
Hi,
I want to record the macro's through which i can automate the data base
that ways i want to enter details in main sheet and data should get
accumulate in compile sheet once i save it.
Please help me out in recording the macro's.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Hi,
I want to record the macro's through which i can automate the data base that
ways i want to enter details in main sheet and data should get accumulate in
compile sheet once i save it.
Please help me out in recording the macro's.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
thank you, thank you so much. working fine.
On Wed, Sep 24, 2014 at 1:20 PM, Ganesh N wrote:
> Dear Shankar,
>
> The modify will choose the particular row (enter the sn. no) and then wht
> ever change u want make (e.g out time) and then click the update button.
>
> Just try if you have doubt let
Dear Shankar,
The modify will choose the particular row (enter the sn. no) and then wht
ever change u want make (e.g out time) and then click the update button.
Just try 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
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 the Modify, a message box asking
for the sl no to modify and I have supplied but nothing is happening.
Modify means, entered fields should reflect on the worksheet na.
Please
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 Bheema
> wrote:
>
>> Good morning all,
>>
31 matches
Mail list logo