Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

[Vaibhav Joshi]

Hi Paul J Irwin,

Solution given is based on then requirement...

Yes you can have search box in forms too

Check this attachment...

Cheers!!

On Sun, Feb 8, 2015 at 7:21 PM, Paul I  wrote:

> Hi Vabs,
>
> This doesnt do the same thing as
> http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/
>
>
> The beauty of the method in the above linked is that it does not matter if
> the string you have started typing is part of the second, first, or any
> word, it will find that string.
>
> So, if i have a list with the following
>
> Apples
> Oranges
> Aardvarks
> Ants
> Leopards
> Pebbles
>
> And i then start typing the string "LE" the above linked will return:
> appLEs, LEopards, pebbLEs whereas your method will only return LEopards.
>
> For my own searches this is important as i am using it to look up a list
> of wine makers, which some people often enter different (i.e. Domaine Paul
> Isgreat, Dom. Paul Isgreat, Paul Isgreat, Domaine Isgreat) so the safest
> bet is to type "ISGREAT" and then see what pops up in the combobox.
>
> I wish there was a way to get the linked combobox into an excel form
> though... It only seems to accept non-ActiveX controls?
>
> --
> 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, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Dynamic Search Box.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

[Paul I]

Hi Vabs,

This doesnt do the same thing 
as http://trumpexcel.com/2013/10/excel-drop-down-list-with-search-suggestions/ 

The beauty of the method in the above linked is that it does not matter if 
the string you have started typing is part of the second, first, or any 
word, it will find that string.

So, if i have a list with the following

Apples
Oranges
Aardvarks
Ants
Leopards
Pebbles

And i then start typing the string "LE" the above linked will return: 
appLEs, LEopards, pebbLEs whereas your method will only return LEopards.

For my own searches this is important as i am using it to look up a list of 
wine makers, which some people often enter different (i.e. Domaine Paul 
Isgreat, Dom. Paul Isgreat, Paul Isgreat, Domaine Isgreat) so the safest 
bet is to type "ISGREAT" and then see what pops up in the combobox.

I wish there was a way to get the linked combobox into an excel form 
though... It only seems to accept non-ActiveX controls?

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

[Abhishek Jain]

Master of search and tell, maybe. :) I never wrote a single line of code
myself as I don't know how to.

Cheers to original coders!

Regards,


On Tue, May 27, 2014 at 5:04 PM, Prafull Jadhav wrote:

> Abhishek Sir,
> Again you proved that you are Master..!
>
> Regards,
> Prafull Jadhav
> 9920553518
>
>
> On 27 May 2014 16:21, Abhishek Jain  wrote:
>
>> Happy to help :)
>>
>>
>> On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal  wrote:
>>
>>> Dear Abhishek Jee,
>>>
>>> It is really a very very helpful for me.
>>> Thanks a ton!
>>>
>>> Regards
>>> Pravin Gunjal.
>>>
>>> -- Forwarded message --
>>> From: Abhishek Jain 
>>> Date: Tue, May 27, 2014 at 4:13 PM
>>> Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few
>>> Automations
>>> To: MS EXCEL AND VBA MACROS , Pravin
>>> Gunjal 
>>>
>>>
>>> If it doesn't necessarily have to be an userform, you can try the
>>> attached.
>>>
>>> Let me know if you need anything further in this.
>>>
>>> Regards, Abhishek
>>>
>>>
>>> On Tue, May 27, 2014 at 3:56 PM, Pravin Gunjal wrote:
>>>
>>>> Dear Friends,
>>>>
>>>> Greetings!
>>>>
>>>> I have an excel file in which I need to have an user form which
>>>> contains the following data:
>>>>
>>>>  *Heading*
>>>>
>>>> *Data Entry*
>>>>
>>>> *Product Name*
>>>>
>>>> By typing any short letter then match value should displayed there in
>>>> list from sheet: "Products"
>>>>
>>>> *Code*
>>>>
>>>> It must come automatically from sheet: "Products", based on the above
>>>> selection
>>>>
>>>> *Quantity*
>>>>
>>>> Manual Entry
>>>>
>>>> *Batch*
>>>>
>>>> Manual Entry
>>>>
>>>> *Reference*
>>>>
>>>> Manual Entry
>>>>
>>>>
>>>> The entered data as per the above method would picked up in second
>>>> sheet (GRRN Entry) from column A4 to E4 and so on..  The file is attached
>>>> fore reference.
>>>>
>>>> Please help.
>>>>
>>>> Regards
>>>> Pravin Gunjal
>>>>
>>>> --
>>>> 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, like Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at http://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>>>  --
>>> 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, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answer

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

[Prafull Jadhav]

Abhishek Sir,
Again you proved that you are Master..!

Regards,
Prafull Jadhav
9920553518


On 27 May 2014 16:21, Abhishek Jain  wrote:

> Happy to help :)
>
>
> On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal  wrote:
>
>> Dear Abhishek Jee,
>>
>> It is really a very very helpful for me.
>> Thanks a ton!
>>
>> Regards
>> Pravin Gunjal.
>>
>> -- Forwarded message --
>> From: Abhishek Jain 
>> Date: Tue, May 27, 2014 at 4:13 PM
>> Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few
>> Automations
>> To: MS EXCEL AND VBA MACROS , Pravin
>> Gunjal 
>>
>>
>> If it doesn't necessarily have to be an userform, you can try the
>> attached.
>>
>> Let me know if you need anything further in this.
>>
>> Regards, Abhishek
>>
>>
>> On Tue, May 27, 2014 at 3:56 PM, Pravin Gunjal  wrote:
>>
>>> Dear Friends,
>>>
>>> Greetings!
>>>
>>> I have an excel file in which I need to have an user form which contains
>>> the following data:
>>>
>>>  *Heading*
>>>
>>> *Data Entry*
>>>
>>> *Product Name*
>>>
>>> By typing any short letter then match value should displayed there in
>>> list from sheet: "Products"
>>>
>>> *Code*
>>>
>>> It must come automatically from sheet: "Products", based on the above
>>> selection
>>>
>>> *Quantity*
>>>
>>> Manual Entry
>>>
>>> *Batch*
>>>
>>> Manual Entry
>>>
>>> *Reference*
>>>
>>> Manual Entry
>>>
>>>
>>> The entered data as per the above method would picked up in second sheet
>>> (GRRN Entry) from column A4 to E4 and so on..  The file is attached fore
>>> reference.
>>>
>>> Please help.
>>>
>>> Regards
>>> Pravin Gunjal
>>>
>>> --
>>> 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, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>  --
>> 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, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving

Re: $$Excel-Macros$$ User Form for Data Entry with few Automations

[Abhishek Jain]

Happy to help :)


On Tue, May 27, 2014 at 4:19 PM, Pravin Gunjal  wrote:

> Dear Abhishek Jee,
>
> It is really a very very helpful for me.
> Thanks a ton!
>
> Regards
> Pravin Gunjal.
>
> -- Forwarded message --
> From: Abhishek Jain 
> Date: Tue, May 27, 2014 at 4:13 PM
> Subject: Re: $$Excel-Macros$$ User Form for Data Entry with few Automations
> To: MS EXCEL AND VBA MACROS , Pravin
> Gunjal 
>
>
> If it doesn't necessarily have to be an userform, you can try the
> attached.
>
> Let me know if you need anything further in this.
>
> Regards, Abhishek
>
>
> On Tue, May 27, 2014 at 3:56 PM, Pravin Gunjal  wrote:
>
>> Dear Friends,
>>
>> Greetings!
>>
>> I have an excel file in which I need to have an user form which contains
>> the following data:
>>
>>  *Heading*
>>
>> *Data Entry*
>>
>> *Product Name*
>>
>> By typing any short letter then match value should displayed there in
>> list from sheet: "Products"
>>
>> *Code*
>>
>> It must come automatically from sheet: "Products", based on the above
>> selection
>>
>> *Quantity*
>>
>> Manual Entry
>>
>> *Batch*
>>
>> Manual Entry
>>
>> *Reference*
>>
>> Manual Entry
>>
>>
>> The entered data as per the above method would picked up in second sheet
>> (GRRN Entry) from column A4 to E4 and so on..  The file is attached fore
>> reference.
>>
>> Please help.
>>
>> Regards
>> Pravin Gunjal
>>
>> --
>> 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, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>
>  --
> 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, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not

Re: $$Excel-Macros$$ User form Find code to ignore if text box is blank

[pavithra murthy]

Hello,

It would be helpful if you could attach the excel sheet also...

Regards,
Pavithra


On Mon, Apr 15, 2013 at 7:48 PM, Thomas Yantorno <
salestaxconsult...@gmail.com> wrote:

> Hello,
>
> I have code that looks to modify a cell when there is a value placed in a
> user form. My issue is that there are multiple text boxes in the user form
> and I only want the user form to update the cell if there is a value, but
> ignore a text box if there is no value. Currently, it will update the cell
> with value but also update if there is no value by blanking out the cell. I
> would like the program to change the cell if there is a value in text box,
> but if text box blank then leave original value intact. Thank you in
> advance.
>
> Sub ALTaxType()
> 'Alabama
> Dim wbData As Workbook, ws1 As Worksheet, lngLastRow As Long, r As Long,
> ans As Variant
>   Set wbData = ThisWorkbook
>   Set ws1 = wbData.Sheets("Sheet1")
>
>
>
> With ws1
> lngLastRow = .Cells.Find(what:="*", After:=.Cells(1, 1),
> LookIn:=xlFormulas, LookAt:=xlPart, _
> SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row
>   For r = lngLastRow To 2 Step -1  ' Assumes row 1 contains col headers
>   If .Cells(r, "A") = "Alabama" Then
> ' Populates column G with textboxvalue
> .Cells(r, "G") = frmTx.txtboxAL.Value ' .Rows(r).Delete ' If you
> want to delete row
>   End If
>   Next r
> End With
>
> End Sub
>
> --
> 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, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
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, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

Re: $$Excel-Macros$$ User form & Query box

[prabhat.shrivasta...@gmail.com]

hi Ashish,

Pl provide the solution, if you can.

On Sunday, October 7, 2012 11:48:00 AM UTC+5:30, prabhat.sh...@gmail.com 
wrote:
>
>
>
> Hi Ashish,
>
> The excel list is consists of account nos in text format in column A i.e. 
> 05223300056, 05223300057, 05223300058 & so on rest will be done 
> by query excel forms/input box.
>
> Regards,
> Prabhat Shrivastava
>
>  On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote:
>
>> can you share the sample file 
>>
>>
>> On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com <
>> prabhat.sh...@gmail.com> wrote:
>>
>>> This group help me a lot for ma assignment time to time, I m really 
>>> happy to be the member of this group.
>>>
>>> here again, I've some query & require help from expert of this group. I 
>>> need to create a user input form.
>>>
>>> I've a list of data in a particular excel spreadsheet, what I want is as 
>>> soon i entered the data in input box of excel that run a query (may be with 
>>> vlookup or find command) & return me with the result that "Data Available" 
>>> or "Data Not Available", if the data is available than, it should store in 
>>> separate sheet or else make input box blank again to enter next record. all 
>>> the data would be in text format & unique.
>>>
>>> Request your help to get a sample sheet with the above condition, 
>>>
>>> Thanks for help in this matter.
>>>
>>> Thanks & Regards,
>>> Prabhat Shrivastava
>>>
>>> -- 
>>> Join official facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>  
>>> FORUM RULES (1120+ 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 Advice 
>>> will not get quick attention or may not be answered.
>>>  
>>> 2) Don't post a question in the thread of another member.
>>>  
>>> 3) Don't post questions regarding breaking or bypassing any security 
>>> measure.
>>>  
>>> 4) Acknowledge the responses you receive, good or bad.
>>>  
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>>> signatures are prohibited. 
>>>  
>>> 6) Jobs posting is not allowed.
>>>  
>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>>  
>>> NOTE : Don't ever post personal or confidential data in a workbook. 
>>> Forum owners and members are not responsible for any loss.
>>> --- 
>>> You received this message because you are subscribed to the Google 
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>> To unsubscribe from this group, send email to 
>>> excel-macros...@googlegroups.com.
>>>  
>>>  
>>>
>>
>>
>>
>> -- 
>> *Regards*
>> * *
>> *Ashish Koul*
>>
>>
>> *Visit*
>> *http://www.excelvbamacros.com/*
>> *http://www.accessvbamacros.com/*
>>
>> P Before printing, think about the environment.
>>
>>  
>>
>>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ User form & Query box

[prabhat.shrivasta...@gmail.com]

Hi Ashish,

The excel list is consists of account nos in text format in column A i.e. 
05223300056, 05223300057, 05223300058 & so on rest will be done 
by query excel forms/input box.

Regards,
Prabhat Shrivastava

 On Sunday, October 7, 2012 11:22:00 AM UTC+5:30, ashish wrote:

> can you share the sample file 
>
>
> On Sun, Oct 7, 2012 at 11:03 AM, prabhat.sh...@gmail.com  <
> prabhat.sh...@gmail.com > wrote:
>
>> This group help me a lot for ma assignment time to time, I m really happy 
>> to be the member of this group.
>>
>> here again, I've some query & require help from expert of this group. I 
>> need to create a user input form.
>>
>> I've a list of data in a particular excel spreadsheet, what I want is as 
>> soon i entered the data in input box of excel that run a query (may be with 
>> vlookup or find command) & return me with the result that "Data Available" 
>> or "Data Not Available", if the data is available than, it should store in 
>> separate sheet or else make input box blank again to enter next record. all 
>> the data would be in text format & unique.
>>
>> Request your help to get a sample sheet with the above condition, 
>>
>> Thanks for help in this matter.
>>
>> Thanks & Regards,
>> Prabhat Shrivastava
>>
>> -- 
>> Join official facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES (1120+ 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 Advice 
>> will not get quick attention or may not be answered.
>>  
>> 2) Don't post a question in the thread of another member.
>>  
>> 3) Don't post questions regarding breaking or bypassing any security 
>> measure.
>>  
>> 4) Acknowledge the responses you receive, good or bad.
>>  
>> 5) Cross-promotion of, or links to, forums competitive to this forum in 
>> signatures are prohibited. 
>>  
>> 6) Jobs posting is not allowed.
>>  
>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>>  
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum 
>> owners and members are not responsible for any loss.
>> --- 
>> You received this message because you are subscribed to the Google Groups 
>> "MS EXCEL AND VBA MACROS" group.
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> To unsubscribe from this group, send email to 
>> excel-macros...@googlegroups.com .
>>  
>>  
>>
>
>
>
> -- 
> *Regards*
> * *
> *Ashish Koul*
>
>
> *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>  
>
>

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ User form & Query box

[ashish koul]

can you share the sample file


On Sun, Oct 7, 2012 at 11:03 AM, prabhat.shrivasta...@gmail.com <
prabhat.shrivasta...@gmail.com> wrote:

> This group help me a lot for ma assignment time to time, I m really happy
> to be the member of this group.
>
> here again, I've some query & require help from expert of this group. I
> need to create a user input form.
>
> I've a list of data in a particular excel spreadsheet, what I want is as
> soon i entered the data in input box of excel that run a query (may be with
> vlookup or find command) & return me with the result that "Data Available"
> or "Data Not Available", if the data is available than, it should store in
> separate sheet or else make input box blank again to enter next record. all
> the data would be in text format & unique.
>
> Request your help to get a sample sheet with the above condition,
>
> Thanks for help in this matter.
>
> Thanks & Regards,
> Prabhat Shrivastava
>
> --
> Join official facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES (1120+ 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 Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> 6) Jobs posting is not allowed.
>
> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To post to this group, send email to excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ 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 Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

6) Jobs posting is not allowed.

7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ User Form

[NOORAIN ANSARI]

Thanks Chilexcel

On Thu, May 24, 2012 at 10:23 PM, ChilExcel  wrote:

> Good Job Noorain Ansari !!!
>
>
> Chilexcel 
>
> 2012/5/24 NOORAIN ANSARI :
> > Dear Deba,
> >
> > Please see attached Userform, hope it will help you.
> >
> >
> > --
> > Thanks & regards,
> > Noorain Ansari
> > www.noorainansari.com
> > www.excelmacroworld.blogspot.com
> >
> > On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan 
> wrote:
> >>
> >> Dear Experts,
> >>
> >> Again i have some concern in user form. Please find the attachment,
> i
> >> have clearly explain in it. Please...
> >>
> >>
> >> Regards
> >> Debaranjan
> >>
> >> --
> >> 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 Advice
> will
> >> not get quick attention or may not be answered.
> >>
> >> 2) Don't post a question in the thread of another member.
> >>
> >> 3) Don't post questions regarding breaking or bypassing any security
> >> measure.
> >>
> >> 4) Acknowledge the responses you receive, good or bad.
> >>
> >> 5) Cross-promotion of, or links to, forums competitive to this forum in
> >> signatures are prohibited.
> >>
> >> NOTE : Don't ever post personal or confidential data in a workbook.
> Forum
> >> owners and members are not responsible for any loss.
> >>
> >>
> >>
> --
> >> To post to this group, send email to excel-macros@googlegroups.com
> >>
> >> To unsubscribe, send a blank email to
> >> excel-macros+unsubscr...@googlegroups.com
> >
> >
> >
> >
> >
> >
> >
> > --
> > 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 Advice
> will
> > not get quick attention or may not be answered.
> >
> > 2) Don't post a question in the thread of another member.
> >
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> >
> > 4) Acknowledge the responses you receive, good or bad.
> >
> > 5) Cross-promotion of, or links to, forums competitive to this forum in
> > signatures are prohibited.
> >
> > NOTE : Don't ever post personal or confidential data in a workbook. Forum
> > owners and members are not responsible for any loss.
> >
> >
> --
> > To post to this group, send email to excel-macros@googlegroups.com
> >
> > To unsubscribe, send a blank email to
> > excel-macros+unsubscr...@googlegroups.com
>
>
>
> --
> Visita ; http://sites.google.com/site/chilexcel/Home
> Visita ; http://www.youtube.com/user/timextag41
>
> --
> 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 Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com
>



-- 
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com

-- 
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 Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ User Form

[ChilExcel]

Good Job Noorain Ansari !!!


Chilexcel 

2012/5/24 NOORAIN ANSARI :
> Dear Deba,
>
> Please see attached Userform, hope it will help you.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
> On Tue, May 22, 2012 at 6:01 PM, Deba Ranjan  wrote:
>>
>> Dear Experts,
>>
>>     Again i have some concern in user form. Please find the attachment, i
>> have clearly explain in it. Please...
>>
>>
>> Regards
>> Debaranjan
>>
>> --
>> 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 Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>
>
>
>
>
>
>
> --
> 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 Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> To unsubscribe, send a blank email to
> excel-macros+unsubscr...@googlegroups.com



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
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 Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Surya,

Try the Below...

*Private Sub Workbook_Open()*
*UserForm1.show*
*End Sub*


*Best Regards,*
*Venkat *
*Chennai*
*
*


On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote:

> Hi Venkat,
>
> Sorry for the wrong attachment, here is the updated one.
>
> What i need is when i open the spread sheet the form should POP
> automatically.
>
> Thanks
> Prasad.
>
>
> On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:
>
>> Hi Surya,
>>
>> Your excel sheet is empty..Please check..
>>
>>  *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
>> wrote:
>>
>>> Hi ,
>>>
>>> Please see my excel spread sheet i need the userform as POP see the chail
>>> mail
>>>
>>> Thanks
>>> Prasad
>>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>>
   What userform? Put this in the ThisWorkbook module

 Private Sub Workbook_Open()
 nameofyouruserformhere.Show
 End Sub

  *From:* Suryaprasad 
 *Sent:* Tuesday, August 30, 2011 7:42 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ User form

   Hi All,

 Need  a small help , i need to get a pop up of the user form when my
 excel is opened, see the attachment

 Thanks
 Prasad.
 --

 --
 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. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 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. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>> --
>>>
>>> --
>>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>>
>>
>> --
>>
>> --
>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>  --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--

Re: $$Excel-Macros$$ User form

[NOORAIN ANSARI]

Dear  surya,

Please see attached sheet..

On Tue, Aug 30, 2011 at 9:00 PM, Suryaprasad wrote:

> Hi Venkat,
>
> Sorry for the wrong attachment, here is the updated one.
>
> What i need is when i open the spread sheet the form should POP
> automatically.
>
> Thanks
> Prasad.
>
>
> On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:
>
>> Hi Surya,
>>
>> Your excel sheet is empty..Please check..
>>
>>  *Best Regards,*
>> *Venkat *
>> *Chennai*
>> *
>> *
>> *
>> *
>>
>>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
>> wrote:
>>
>>> Hi ,
>>>
>>> Please see my excel spread sheet i need the userform as POP see the chail
>>> mail
>>>
>>> Thanks
>>> Prasad
>>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>>
   What userform? Put this in the ThisWorkbook module

 Private Sub Workbook_Open()
 nameofyouruserformhere.Show
 End Sub

  *From:* Suryaprasad 
 *Sent:* Tuesday, August 30, 2011 7:42 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ User form

   Hi All,

 Need  a small help , i need to get a pop up of the user form when my
 excel is opened, see the attachment

 Thanks
 Prasad.
 --

 --
 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. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

 --

 --
 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. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>> --
>>>
>>> --
>>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>>
>>
>> --
>>
>> --
>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Thanks & regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/* 

-- 
-

Re: $$Excel-Macros$$ User form

[Suryaprasad]

Hi Venkat,

Sorry for the wrong attachment, here is the updated one.

What i need is when i open the spread sheet the form should POP
automatically.

Thanks
Prasad.


On Tue, Aug 30, 2011 at 7:36 PM, Venkat CV  wrote:

> Hi Surya,
>
> Your excel sheet is empty..Please check..
>
>  *Best Regards,*
> *Venkat *
> *Chennai*
> *
> *
> *
> *
>
>   On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad 
> wrote:
>
>> Hi ,
>>
>> Please see my excel spread sheet i need the userform as POP see the chail
>> mail
>>
>> Thanks
>> Prasad
>>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>>
>>>   What userform? Put this in the ThisWorkbook module
>>>
>>> Private Sub Workbook_Open()
>>> nameofyouruserformhere.Show
>>> End Sub
>>>
>>>  *From:* Suryaprasad 
>>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ User form
>>>
>>>   Hi All,
>>>
>>> Need  a small help , i need to get a pop up of the user form when my
>>> excel is opened, see the attachment
>>>
>>> Thanks
>>> Prasad.
>>> --
>>>
>>> --
>>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>> --
>>>
>>> --
>>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>> --
>>
>> --
>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
>
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


User.xlsm
Description: Binary data

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Surya,

Your excel sheet is empty..Please check..

 *Best Regards,*
*Venkat *
*Chennai*
*
*
*
*

On Tue, Aug 30, 2011 at 7:26 PM, Suryaprasad wrote:

> Hi ,
>
> Please see my excel spread sheet i need the userform as POP see the chail
> mail
>
> Thanks
> Prasad
>   On Tue, Aug 30, 2011 at 6:39 PM, dguillett1 wrote:
>
>>   What userform? Put this in the ThisWorkbook module
>>
>> Private Sub Workbook_Open()
>> nameofyouruserformhere.Show
>> End Sub
>>
>>  *From:* Suryaprasad 
>> *Sent:* Tuesday, August 30, 2011 7:42 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ User form
>>
>>   Hi All,
>>
>> Need  a small help , i need to get a pop up of the user form when my excel
>> is opened, see the attachment
>>
>> Thanks
>> Prasad.
>> --
>>
>> --
>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>> --
>>
>> --
>> 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. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



--

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ User form

[Suryaprasad]

Hi ,

Please see my excel spread sheet i need the userform as POP see the chail
mail

Thanks
Prasad
On Tue, Aug 30, 2011 at 6:39 PM, dguillett1  wrote:

>   What userform? Put this in the ThisWorkbook module
>
> Private Sub Workbook_Open()
> nameofyouruserformhere.Show
> End Sub
>
>  *From:* Suryaprasad 
> *Sent:* Tuesday, August 30, 2011 7:42 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ User form
>
>   Hi All,
>
> Need  a small help , i need to get a pop up of the user form when my excel
> is opened, see the attachment
>
> Thanks
> Prasad.
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ User form

[dguillett1]

What userform? Put this in the ThisWorkbook module

Private Sub Workbook_Open()
nameofyouruserformhere.Show 
End Sub 

From: Suryaprasad 
Sent: Tuesday, August 30, 2011 7:42 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ User form

Hi All,

Need  a small help , i need to get a pop up of the user form when my excel is 
opened, see the attachment

Thanks
Prasad.
-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ User form

[Venkat CV]

Hi Prasad,

Look attached below...

If you want to create some VBA Coding in background of userforms..You have
to save the file has a .XLS or

XLSM because XLSX wont support Macro Language..


*Best Regards,*
*Venkat *
*Chennai*

On Tue, Aug 30, 2011 at 6:12 PM, Suryaprasad wrote:

> Hi All,
>
> Need  a small help , i need to get a pop up of the user form when my excel
> is opened, see the attachment
>
> Thanks
> Prasad.
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
*
*
*
*

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Auto_Open.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

[santosh bahuguna]

again you should use ratio buttion on this

Please find attached solution


Regards
Santosh Bahuguna
On Tue, Jun 28, 2011 at 11:53 PM, Rash  wrote:

> Hi all,
>
> Need Help...
>
> I have a user form in which i have 6 check boxes. ok and cancel button.
>
> when ever I click 1st check box, rows 1 to 10 should to be editable, rest
> all rows should be non editable and hidden.
>
> For check box 2, rows 11 to 20 editable, rest up and down area should be
> non editable and hidden. And vice versa for other check boxes.
>
>  I need a macro for this. Attached is the excel sheet with user form
> created in background.
>
> Thanks in advance,
> Rsh
>
> --
>
> --
> 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. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


test.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ User form + Macro to activate certain region of active work sheet.

[STDEV(i)]

Dim ws As Worksheet
Const pass As String = "rash"
Dim ArChkBox(1 To 6) As Object

Private Sub UserForm_Activate()
   Set ArChkBox(1) = CheckBox1
   Set ArChkBox(2) = CheckBox2
   Set ArChkBox(3) = CheckBox3
   Set ArChkBox(4) = CheckBox4
   Set ArChkBox(5) = CheckBox5
   Set ArChkBox(6) = CheckBox6
End Sub

Private Sub Locked_Unlocked(Rowval As Long)
   Dim r As Long
   r = Rowval * 10 - 9
   Sheet1.Unprotect pass
   Sheet1.Cells.Locked = True
   If ArChkBox(Rowval) Then
  Cells(r, 1).Resize(10, 1).EntireRow.Locked = False
   Else
  Cells(r, 1).Resize(10, 1).EntireRow.Locked = True
   End If
   Sheet1.Protect pass
   If Rowval > 1 Then ActiveWindow.ScrollRow = r - 2 Else:
ActiveWindow.ScrollRow = r
   Cells(r, 1).Resize(10, 1).EntireRow.Select
End Sub

Private Sub CheckBox1_Click()
   Call Locked_Unlocked(1)
End Sub
Private Sub CheckBox2_Click()
   Call Locked_Unlocked(2)
End Sub
Private Sub CheckBox3_Click()
   Call Locked_Unlocked(3)
End Sub
Private Sub CheckBox4_Click()
   Call Locked_Unlocked(4)
End Sub
Private Sub CheckBox5_Click()
   Call Locked_Unlocked(5)
End Sub
Private Sub CheckBox6_Click()
   Call Locked_Unlocked(6)
End Sub




On Wed, Jun 29, 2011 at 1:53 PM, Rash  wrote:

> Hi all,
>
> Need Help...
>
> I have a user form in which i have 6 check boxes. ok and cancel button.
>
> when ever I click 1st check box, rows 1 to 10 should to be editable, rest
> all rows should be non editable and hidden.
>
> For check box 2, rows 11 to 20 editable, rest up and down area should be
> non editable and hidden. And vice versa for other check boxes.
>
> I need a macro for this. Attached is the excel sheet with user form created
> in background.
>
> Thanks in advance,
> Rsh
>
>

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


ctv_Test_Cells_Locking_Unlocking.xlsm
Description: Binary data

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

Hi Paul,

Thanks aton
It's working perfect
And I done it for userform2... :)
Learned alot

Thanks once again for your continuous help/guidance :)  :)  :)

Regds,
Manish

On Feb 7, 10:16�pm, Paul Schreiner  wrote:
> Manish,
>
> I'm sorry... I've been away from my computer(s) for a few days.
>
> I'll try to take a look today.
>  I thought I sent it, but don't see it, so I'll have to re-create it.
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Mon, February 7, 2011 10:34:59 AM
> Subject: Re: $$Excel-Macros$$ User form value in current active row
>
> Any help pls.
>
> -
> Manish
>
> On Feb 7, 12:12 pm, Manish  wrote:
>
>
>
> > Dear Paul & EE,
>
> > I want to write the value of userform in same PRA worksheet in column
> > T:AA in same row.
>
> > For example: if user enter the value is in PRA Sheet column M8,
> > userform will write the value in cell T8:AA8, same as if user enter
> > the value in PRA Sheet column M11, I want to write the userform value
> > in cell T11:AA11. Further if user change the previous entered value, I
> > want to show the same row value in userform textboxes like if user
> > change the value in cell M8, I want the user form open with the value
> > already I have in cell T8:AA8 and by clicking the OK button will
> > replace the value in cell T8:AA8. I hope my query/imagination is
> > clear.
>
> > Mr. Paul suggested me the following changes, but I don't know the way
> > to incorporate the same in my excel file.
>
> > Try this:
> > Declare a variable:
> >             Public CellRange As Range
> >  In the Change Event, set CellRange = to the cell that was changed:
>
> >         Set CellRange = Target
>
> > This will make it available to the userform buttons.
> > Next.. Create a Userform Initialize macro:
>
> > Private Sub UserForm_Initialize()
> >     UserForm1.TextBox1 = Cells(CellRange.Row, "T").Value
> >     UserForm1.TextBox2 = Cells(CellRange.Row, "U").Value
> >     UserForm1.TextBox3 = Cells(CellRange.Row, "V").Value
> >     UserForm1.TextBox4 = Cells(CellRange.Row, "W").Value
> >     UserForm1.TextBox5 = Cells(CellRange.Row, "X").Value
> >     UserForm1.TextBox6 = Cells(CellRange.Row, "Y").Value
> >     UserForm1.TextBox7 = CellRange.Value
> >     UserForm1.TextBox16 = Cells(CellRange.Row, "AA").Value
> > End Sub
>
> > In the OK button:
>
> > Sheets("PRA").Cells(CellRange.Row, "T") = TextBox1.Value
> > Sheets("PRA").Cells(CellRange.Row, "U") = TextBox2.Value
> > Sheets("PRA").Cells(CellRange.Row, "V") = TextBox3.Value
> > Sheets("PRA").Cells(CellRange.Row, "W") = TextBox4.Value
> > Sheets("PRA").Cells(CellRange.Row, "X") = TextBox5.Value
> > Sheets("PRA").Cells(CellRange.Row, "Y") = TextBox6.Value
> > Sheets("PRA").Cells(CellRange.Row, "Z") = TextBox7.Value
> > Sheets("PRA").Cells(CellRange.Row, "AA") = TextBox16.Value
>
> > Can anyone please incorporate it in my excel file.
> > I am mailing my file on excel-macros@googlegroups.com
>
> > Regds,
> > Manish Pansari
>
> > On Feb 1, 7:26 pm, Manish  wrote:
>
> > > Thank Paul,
> > > I don't have ops to attach file on group. Can I send you my file
> > > through mail on your personal mail id?
>
> > > -
> > > Manish
>
> > > On Jan 31, 7:57 pm, Paul Schreiner  wrote:
>
> > > > Was able to finish writing scripts to load all tables (1,384,800 
> > > > records).
> > > > Now just have to wait to get a "fresh" data dump and run it complete.
> > > > It takes about 4 hours, because I have to use the Development server.
> > > > thanks for asking.
>
> > > > Now, about your issue.
>
> > > > you're "not comfortable when sheet is protected".
>
> > > > is the entire sheet locked/protected?
>
> > > > Do you have control over the protection? or is it owned by others?
>
> > > > how do you want it to behave?
>
> > > > can you send me what you have so far and let me look at it?
>
> > > > Paul
>
> > > > 
> > > > From: Manish 
> > > > To: MS EXCEL AND VBA MACROS 
> > > > Sent: Mon, January 31, 2011 6:23:04 AM

Re: $$Excel-Macros$$ User form value in current active row

[Paul Schreiner]

Manish,

I'm sorry... I've been away from my computer(s) for a few days.

I'll try to take a look today. 
 I thought I sent it, but don't see it, so I'll have to re-create it.

Paul





From: Manish 
To: MS EXCEL AND VBA MACROS 
Sent: Mon, February 7, 2011 10:34:59 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row

Any help pls.

-
Manish

On Feb 7, 12:12 pm, Manish  wrote:
> Dear Paul & EE,
>
> I want to write the value of userform in same PRA worksheet in column
> T:AA in same row.
>
> For example: if user enter the value is in PRA Sheet column M8,
> userform will write the value in cell T8:AA8, same as if user enter
> the value in PRA Sheet column M11, I want to write the userform value
> in cell T11:AA11. Further if user change the previous entered value, I
> want to show the same row value in userform textboxes like if user
> change the value in cell M8, I want the user form open with the value
> already I have in cell T8:AA8 and by clicking the OK button will
> replace the value in cell T8:AA8. I hope my query/imagination is
> clear.
>
> Mr. Paul suggested me the following changes, but I don't know the way
> to incorporate the same in my excel file.
>
> Try this:
> Declare a variable:
>             Public CellRange As Range
>  In the Change Event, set CellRange = to the cell that was changed:
>
>         Set CellRange = Target
>
> This will make it available to the userform buttons.
> Next.. Create a Userform Initialize macro:
>
> Private Sub UserForm_Initialize()
>     UserForm1.TextBox1 = Cells(CellRange.Row, "T").Value
>     UserForm1.TextBox2 = Cells(CellRange.Row, "U").Value
>     UserForm1.TextBox3 = Cells(CellRange.Row, "V").Value
>     UserForm1.TextBox4 = Cells(CellRange.Row, "W").Value
>     UserForm1.TextBox5 = Cells(CellRange.Row, "X").Value
>     UserForm1.TextBox6 = Cells(CellRange.Row, "Y").Value
>     UserForm1.TextBox7 = CellRange.Value
>     UserForm1.TextBox16 = Cells(CellRange.Row, "AA").Value
> End Sub
>
> In the OK button:
>
> Sheets("PRA").Cells(CellRange.Row, "T") = TextBox1.Value
> Sheets("PRA").Cells(CellRange.Row, "U") = TextBox2.Value
> Sheets("PRA").Cells(CellRange.Row, "V") = TextBox3.Value
> Sheets("PRA").Cells(CellRange.Row, "W") = TextBox4.Value
> Sheets("PRA").Cells(CellRange.Row, "X") = TextBox5.Value
> Sheets("PRA").Cells(CellRange.Row, "Y") = TextBox6.Value
> Sheets("PRA").Cells(CellRange.Row, "Z") = TextBox7.Value
> Sheets("PRA").Cells(CellRange.Row, "AA") = TextBox16.Value
>
> Can anyone please incorporate it in my excel file.
> I am mailing my file on excel-macros@googlegroups.com
>
> Regds,
> Manish Pansari
>
> On Feb 1, 7:26 pm, Manish  wrote:
>
>
>
> > Thank Paul,
> > I don't have ops to attach file on group. Can I send you my file
> > through mail on your personal mail id?
>
> > -
> > Manish
>
> > On Jan 31, 7:57 pm, Paul Schreiner  wrote:
>
> > > Was able to finish writing scripts to load all tables (1,384,800 records).
> > > Now just have to wait to get a "fresh" data dump and run it complete.
> > > It takes about 4 hours, because I have to use the Development server.
> > > thanks for asking.
>
> > > Now, about your issue.
>
> > > you're "not comfortable when sheet is protected".
>
> > > is the entire sheet locked/protected?
>
> > > Do you have control over the protection? or is it owned by others?
>
> > > how do you want it to behave?
>
> > > can you send me what you have so far and let me look at it?
>
> > > Paul
>
> > > 
> > > From: Manish 
> > > To: MS EXCEL AND VBA MACROS 
> > > Sent: Mon, January 31, 2011 6:23:04 AM
> > > Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow
>
> > > I tried the code suggested by you. It s working
> > > Bt I am not comfortable when sheet it protected.
> > > If possible, pls attach the sample file.
>
> > > Thanks once again!!
>
> > > What about your new development 600,000 records into an Oracle
> > > database ?
> > > I know, you are mastermind and you done it. :)
>
> > > Regards,
> > > Manish
>
> > > On Jan 25, 6:38 pm, Paul Schreiner  wrote:
>
> > > > I've got a macro running right now, so I cannot test the code, but

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

Any help pls.

-
Manish

On Feb 7, 12:12 pm, Manish  wrote:
> Dear Paul & EE,
>
> I want to write the value of userform in same PRA worksheet in column
> T:AA in same row.
>
> For example: if user enter the value is in PRA Sheet column M8,
> userform will write the value in cell T8:AA8, same as if user enter
> the value in PRA Sheet column M11, I want to write the userform value
> in cell T11:AA11. Further if user change the previous entered value, I
> want to show the same row value in userform textboxes like if user
> change the value in cell M8, I want the user form open with the value
> already I have in cell T8:AA8 and by clicking the OK button will
> replace the value in cell T8:AA8. I hope my query/imagination is
> clear.
>
> Mr. Paul suggested me the following changes, but I don't know the way
> to incorporate the same in my excel file.
>
> Try this:
> Declare a variable:
>             Public CellRange As Range
>  In the Change Event, set CellRange = to the cell that was changed:
>
>         Set CellRange = Target
>
> This will make it available to the userform buttons.
> Next.. Create a Userform Initialize macro:
>
> Private Sub UserForm_Initialize()
>     UserForm1.TextBox1 = Cells(CellRange.Row, "T").Value
>     UserForm1.TextBox2 = Cells(CellRange.Row, "U").Value
>     UserForm1.TextBox3 = Cells(CellRange.Row, "V").Value
>     UserForm1.TextBox4 = Cells(CellRange.Row, "W").Value
>     UserForm1.TextBox5 = Cells(CellRange.Row, "X").Value
>     UserForm1.TextBox6 = Cells(CellRange.Row, "Y").Value
>     UserForm1.TextBox7 = CellRange.Value
>     UserForm1.TextBox16 = Cells(CellRange.Row, "AA").Value
> End Sub
>
> In the OK button:
>
> Sheets("PRA").Cells(CellRange.Row, "T") = TextBox1.Value
> Sheets("PRA").Cells(CellRange.Row, "U") = TextBox2.Value
> Sheets("PRA").Cells(CellRange.Row, "V") = TextBox3.Value
> Sheets("PRA").Cells(CellRange.Row, "W") = TextBox4.Value
> Sheets("PRA").Cells(CellRange.Row, "X") = TextBox5.Value
> Sheets("PRA").Cells(CellRange.Row, "Y") = TextBox6.Value
> Sheets("PRA").Cells(CellRange.Row, "Z") = TextBox7.Value
> Sheets("PRA").Cells(CellRange.Row, "AA") = TextBox16.Value
>
> Can anyone please incorporate it in my excel file.
> I am mailing my file on excel-macros@googlegroups.com
>
> Regds,
> Manish Pansari
>
> On Feb 1, 7:26 pm, Manish  wrote:
>
>
>
> > Thank Paul,
> > I don't have ops to attach file on group. Can I send you my file
> > through mail on your personal mail id?
>
> > -
> > Manish
>
> > On Jan 31, 7:57 pm, Paul Schreiner  wrote:
>
> > > Was able to finish writing scripts to load all tables (1,384,800 records).
> > > Now just have to wait to get a "fresh" data dump and run it complete.
> > > It takes about 4 hours, because I have to use the Development server.
> > > thanks for asking.
>
> > > Now, about your issue.
>
> > > you're "not comfortable when sheet is protected".
>
> > > is the entire sheet locked/protected?
>
> > > Do you have control over the protection? or is it owned by others?
>
> > > how do you want it to behave?
>
> > > can you send me what you have so far and let me look at it?
>
> > > Paul
>
> > > 
> > > From: Manish 
> > > To: MS EXCEL AND VBA MACROS 
> > > Sent: Mon, January 31, 2011 6:23:04 AM
> > > Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow
>
> > > I tried the code suggested by you. It s working
> > > Bt I am not comfortable when sheet it protected.
> > > If possible, pls attach the sample file.
>
> > > Thanks once again!!
>
> > > What about your new development 600,000 records into an Oracle
> > > database ?
> > > I know, you are mastermind and you done it. :)
>
> > > Regards,
> > > Manish
>
> > > On Jan 25, 6:38 pm, Paul Schreiner  wrote:
>
> > > > I've got a macro running right now, so I cannot test the code, but I can
> > > > describe it!
>
> > > > Right-click on your sheet name "tab" and select "View Code".
> > > > In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
> > > > The "default" event may be the Worksheet_Change event
> > > > or the WorkSheetSelection_Change event.
> > > > If it's the Change event, use the right-hand pull-down to select
> > > > the SelectionChange event.
>
> > > > This macro will "trigger" whenever you select a cell on the sheet.
>
> > > > It passes the cell "range" as a variable called "Target".
>
> > > > Now, the issue here is that if you select more than one cell,
> > > > the Target variable is an array instead of a single range.
> > > > So, I usually test it:
> > > > if (Target.count = 1) then
>
> > > > next,  test to see if the column of the cell is column "B"
> > > > If (Target.Column  = 2) then
>
> > > > You can save theRownumber by using:
> > > > CurRow = Target.Row
>
> > > > Of course, within youruserformmacros, you can use ActiveCell.Row
>
> > > > Now, to launch youruserform, use:  UserFormName.Show
>
> > > > Give that a try.
> > > > If you need more help, let me know and I'll write it when my  macro 
> > > > finishes.
> > > > 

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

Dear Paul & EE,

I want to write the value of userform in same PRA worksheet in column
T:AA in same row.

For example: if user enter the value is in PRA Sheet column M8,
userform will write the value in cell T8:AA8, same as if user enter
the value in PRA Sheet column M11, I want to write the userform value
in cell T11:AA11. Further if user change the previous entered value, I
want to show the same row value in userform textboxes like if user
change the value in cell M8, I want the user form open with the value
already I have in cell T8:AA8 and by clicking the OK button will
replace the value in cell T8:AA8. I hope my query/imagination is
clear.

Mr. Paul suggested me the following changes, but I don't know the way
to incorporate the same in my excel file.

Try this:
Declare a variable:
Public CellRange As Range
 In the Change Event, set CellRange = to the cell that was changed:

Set CellRange = Target

This will make it available to the userform buttons.
Next.. Create a Userform Initialize macro:


Private Sub UserForm_Initialize()
UserForm1.TextBox1 = Cells(CellRange.Row, "T").Value
UserForm1.TextBox2 = Cells(CellRange.Row, "U").Value
UserForm1.TextBox3 = Cells(CellRange.Row, "V").Value
UserForm1.TextBox4 = Cells(CellRange.Row, "W").Value
UserForm1.TextBox5 = Cells(CellRange.Row, "X").Value
UserForm1.TextBox6 = Cells(CellRange.Row, "Y").Value
UserForm1.TextBox7 = CellRange.Value
UserForm1.TextBox16 = Cells(CellRange.Row, "AA").Value
End Sub

In the OK button:

Sheets("PRA").Cells(CellRange.Row, "T") = TextBox1.Value
Sheets("PRA").Cells(CellRange.Row, "U") = TextBox2.Value
Sheets("PRA").Cells(CellRange.Row, "V") = TextBox3.Value
Sheets("PRA").Cells(CellRange.Row, "W") = TextBox4.Value
Sheets("PRA").Cells(CellRange.Row, "X") = TextBox5.Value
Sheets("PRA").Cells(CellRange.Row, "Y") = TextBox6.Value
Sheets("PRA").Cells(CellRange.Row, "Z") = TextBox7.Value
Sheets("PRA").Cells(CellRange.Row, "AA") = TextBox16.Value


Can anyone please incorporate it in my excel file.
I am mailing my file on excel-macros@googlegroups.com

Regds,
Manish Pansari

On Feb 1, 7:26 pm, Manish  wrote:
> Thank Paul,
> I don't have ops to attach file on group. Can I send you my file
> through mail on your personal mail id?
>
> -
> Manish
>
> On Jan 31, 7:57 pm, Paul Schreiner  wrote:
>
>
>
> > Was able to finish writing scripts to load all tables (1,384,800 records).
> > Now just have to wait to get a "fresh" data dump and run it complete.
> > It takes about 4 hours, because I have to use the Development server.
> > thanks for asking.
>
> > Now, about your issue.
>
> > you're "not comfortable when sheet is protected".
>
> > is the entire sheet locked/protected?
>
> > Do you have control over the protection? or is it owned by others?
>
> > how do you want it to behave?
>
> > can you send me what you have so far and let me look at it?
>
> > Paul
>
> > 
> > From: Manish 
> > To: MS EXCEL AND VBA MACROS 
> > Sent: Mon, January 31, 2011 6:23:04 AM
> > Subject: Re: $$Excel-Macros$$ User formvalueincurrentactiverow
>
> > I tried the code suggested by you. It s working
> > Bt I am not comfortable when sheet it protected.
> > If possible, pls attach the sample file.
>
> > Thanks once again!!
>
> > What about your new development 600,000 records into an Oracle
> > database ?
> > I know, you are mastermind and you done it. :)
>
> > Regards,
> > Manish
>
> > On Jan 25, 6:38 pm, Paul Schreiner  wrote:
>
> > > I've got a macro running right now, so I cannot test the code, but I can
> > > describe it!
>
> > > Right-click on your sheet name "tab" and select "View Code".
> > > In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
> > > The "default" event may be the Worksheet_Change event
> > > or the WorkSheetSelection_Change event.
> > > If it's the Change event, use the right-hand pull-down to select
> > > the SelectionChange event.
>
> > > This macro will "trigger" whenever you select a cell on the sheet.
>
> > > It passes the cell "range" as a variable called "Target".
>
> > > Now, the issue here is that if you select more than one cell,
> > > the Target variable is an array instead of a single range.
> > > So, I usually test it:
> > > if (Target.count = 1) then
>
> > > next,  test to see if the column of the cell is column "B"
> > > If (Target.Column  = 2) then
>
> > > You can save theRownumber by using:
> > > CurRow = Target.Row
>
> > > Of course, within youruserformmacros, you can use ActiveCell.Row
>
> > > Now, to launch youruserform, use:  UserFormName.Show
>
> > > Give that a try.
> > > If you need more help, let me know and I'll write it when my  macro 
> > > finishes.
> > > (It's loading 600,000 records into an Oracle database.. it takes a while)
>
> > > Paul
>
> > > 
> > > From: Manish 
> > > To: MS EXCEL AND VBA MACROS 
> > > Sent: Tue, January 25, 2011 8:10:47 AM
> > > Subject: Re: $$Excel-Macros$$ User formv

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

Thank Paul,
I don't have ops to attach file on group. Can I send you my file
through mail on your personal mail id?

-
Manish


On Jan 31, 7:57 pm, Paul Schreiner  wrote:
> Was able to finish writing scripts to load all tables (1,384,800 records).
> Now just have to wait to get a "fresh" data dump and run it complete.
> It takes about 4 hours, because I have to use the Development server.
> thanks for asking.
>
> Now, about your issue.
>
> you're "not comfortable when sheet is protected".
>
> is the entire sheet locked/protected?
>
> Do you have control over the protection? or is it owned by others?
>
> how do you want it to behave?
>
> can you send me what you have so far and let me look at it?
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Mon, January 31, 2011 6:23:04 AM
> Subject: Re: $$Excel-Macros$$ User form value in current active row
>
> I tried the code suggested by you. It s working
> Bt I am not comfortable when sheet it protected.
> If possible, pls attach the sample file.
>
> Thanks once again!!
>
> What about your new development 600,000 records into an Oracle
> database ?
> I know, you are mastermind and you done it. :)
>
> Regards,
> Manish
>
> On Jan 25, 6:38 pm, Paul Schreiner  wrote:
>
>
>
>
>
> > I've got a macro running right now, so I cannot test the code, but I can
> > describe it!
>
> > Right-click on your sheet name "tab" and select "View Code".
> > In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
> > The "default" event may be the Worksheet_Change event
> > or the WorkSheetSelection_Change event.
> > If it's the Change event, use the right-hand pull-down to select
> > the SelectionChange event.
>
> > This macro will "trigger" whenever you select a cell on the sheet.
>
> > It passes the cell "range" as a variable called "Target".
>
> > Now, the issue here is that if you select more than one cell,
> > the Target variable is an array instead of a single range.
> > So, I usually test it:
> > if (Target.count = 1) then
>
> > next,  test to see if the column of the cell is column "B"
> > If (Target.Column  = 2) then
>
> > You can save the Row number by using:
> > CurRow = Target.Row
>
> > Of course, within your userform macros, you can use ActiveCell.Row
>
> > Now, to launch your userform, use:  UserFormName.Show
>
> > Give that a try.
> > If you need more help, let me know and I'll write it when my  macro 
> > finishes.
> > (It's loading 600,000 records into an Oracle database.. it takes a while)
>
> > Paul
>
> > 
> > From: Manish 
> > To: MS EXCEL AND VBA MACROS 
> > Sent: Tue, January 25, 2011 8:10:47 AM
> > Subject: Re: $$Excel-Macros$$ User form value in current active row
>
> > Thanks Paul.
> > My column is selectable.
> > If user select/edit in the cell e.g. B3, i want to open the user form
> > and want to write user form value in same row i.e. row3 in column C to
> > H. And also i want to put total CtoH in column B.
>
> > Thanks in advance.
>
> > Regds,
> > Manish
>
> > On Jan 25, 5:54 pm, Paul Schreiner  wrote:
>
> > > Is column B "selectable"?
>
> > > (When setting protection, it is possible to protect the cell
> > > from changes, yet allow the user to select the cell)
>
> > > If it is, then you can use a Selection_Change event
> > > and check:
> > > If (Target.Column = 2) then
>
> > > within the event, you can open the userform.
>
> > > You'll be able to make changes to other cells,
> > > but to make changes to column B, you'll have to
> > > know the password and unprotect the sheet.
>
> > > Paul
>
> > > 
> > > From: Manish 
> > > To: MS EXCEL AND VBA MACROS 
> > > Sent: Tue, January 25, 2011 1:37:03 AM
> > > Subject: $$Excel-Macros$$ User form value in current active row
>
> > > Dear Excel Experts,
>
> > > Can you please suggest me the code for following task.
>
> > > My sheet is password protected and Column B is locked. When user try
> > > to enter the data in any cell of column B, I want to open one user
> > > form.
> > > I am comfortable with build the user form. In my user form I have six
> > > TaxtBox, I want to write the data of user form in same sheet act

Re: $$Excel-Macros$$ User form value in current active row

[Paul Schreiner]

Was able to finish writing scripts to load all tables (1,384,800 records).
Now just have to wait to get a "fresh" data dump and run it complete.
It takes about 4 hours, because I have to use the Development server.
thanks for asking.

Now, about your issue.

you're "not comfortable when sheet is protected".

is the entire sheet locked/protected?

Do you have control over the protection? or is it owned by others?

how do you want it to behave?

can you send me what you have so far and let me look at it?

Paul





From: Manish 
To: MS EXCEL AND VBA MACROS 
Sent: Mon, January 31, 2011 6:23:04 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row

I tried the code suggested by you. It�s working�
Bt I am not comfortable when sheet it protected.
If possible, pls attach the sample file.

Thanks once again!!

What about your new development �600,000 records into an Oracle
database�?
I know, you are mastermind and you done it. :)

Regards,
Manish

On Jan 25, 6:38�pm, Paul Schreiner  wrote:
> I've got a macro running right now, so I cannot test the code, but I can
> describe it!
>
> Right-click on your sheet name "tab" and select "View Code".
> In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
> The "default" event may be the Worksheet_Change event
> or the WorkSheetSelection_Change event.
> If it's the Change event, use the right-hand pull-down to select
> the SelectionChange event.
>
> This macro will "trigger" whenever you select a cell on the sheet.
>
> It passes the cell "range" as a variable called "Target".
>
> Now, the issue here is that if you select more than one cell,
> the Target variable is an array instead of a single range.
> So, I usually test it:
> if (Target.count = 1) then
>
> next,  test to see if the column of the cell is column "B"
> If (Target.Column  = 2) then
>
> You can save the Row number by using:
> CurRow = Target.Row
>
> Of course, within your userform macros, you can use ActiveCell.Row
>
> Now, to launch your userform, use:  UserFormName.Show
>
> Give that a try.
> If you need more help, let me know and I'll write it when my  macro finishes.
> (It's loading 600,000 records into an Oracle database.. it takes a while)
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Tue, January 25, 2011 8:10:47 AM
> Subject: Re: $$Excel-Macros$$ User form value in current active row
>
> Thanks Paul.
> My column is selectable.
> If user select/edit in the cell e.g. B3, i want to open the user form
> and want to write user form value in same row i.e. row3 in column C to
> H. And also i want to put total CtoH in column B.
>
> Thanks in advance.
>
> Regds,
> Manish
>
> On Jan 25, 5:54 pm, Paul Schreiner  wrote:
>
>
>
>
>
> > Is column B "selectable"?
>
> > (When setting protection, it is possible to protect the cell
> > from changes, yet allow the user to select the cell)
>
> > If it is, then you can use a Selection_Change event
> > and check:
> > If (Target.Column = 2) then
>
> > within the event, you can open the userform.
>
> > You'll be able to make changes to other cells,
> > but to make changes to column B, you'll have to
> > know the password and unprotect the sheet.
>
> > Paul
>
> > 
> > From: Manish 
> > To: MS EXCEL AND VBA MACROS 
> > Sent: Tue, January 25, 2011 1:37:03 AM
> > Subject: $$Excel-Macros$$ User form value in current active row
>
> > Dear Excel Experts,
>
> > Can you please suggest me the code for following task.
>
> > My sheet is password protected and Column B is locked. When user try
> > to enter the data in any cell of column B, I want to open one user
> > form.
> > I am comfortable with build the user form. In my user form I have six
> > TaxtBox, I want to write the data of user form in same sheet active
> > row column C to H.
>
> > I know the write the user form data in new worksheet, but I don’t know
> > the code to write the data in active row and also the code for open
> > the Userform, if my cell is locked.
>
> > Pls help.
>
> > Thanks in Advance…
>
> > Regds,
> > Manish Pansari
> > +91 9810 88 8281
>
> > --
>>--�-­---
>-
> >-
>
> > Some important links for excel users:
> > 1. Follow us on TWITTER for tips tricks and links
> >:http://twitter.com/exceldailytip
> > 2. 

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

I tried the code suggested by you. It�s working�
Bt I am not comfortable when sheet it protected.
If possible, pls attach the sample file.

Thanks once again!!

What about your new development �600,000 records into an Oracle
database�?
I know, you are mastermind and you done it. :)

Regards,
Manish

On Jan 25, 6:38�pm, Paul Schreiner  wrote:
> I've got a macro running right now, so I cannot test the code, but I can
> describe it!
>
> Right-click on your sheet name "tab" and select "View Code".
> In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
> The "default" event may be the Worksheet_Change event
> or the WorkSheetSelection_Change event.
> If it's the Change event, use the right-hand pull-down to select
> the SelectionChange event.
>
> This macro will "trigger" whenever you select a cell on the sheet.
>
> It passes the cell "range" as a variable called "Target".
>
> Now, the issue here is that if you select more than one cell,
> the Target variable is an array instead of a single range.
> So, I usually test it:
> if (Target.count = 1) then
>
> next,  test to see if the column of the cell is column "B"
> If (Target.Column  = 2) then
>
> You can save the Row number by using:
> CurRow = Target.Row
>
> Of course, within your userform macros, you can use ActiveCell.Row
>
> Now, to launch your userform, use:  UserFormName.Show
>
> Give that a try.
> If you need more help, let me know and I'll write it when my  macro finishes.
> (It's loading 600,000 records into an Oracle database.. it takes a while)
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Tue, January 25, 2011 8:10:47 AM
> Subject: Re: $$Excel-Macros$$ User form value in current active row
>
> Thanks Paul.
> My column is selectable.
> If user select/edit in the cell e.g. B3, i want to open the user form
> and want to write user form value in same row i.e. row3 in column C to
> H. And also i want to put total CtoH in column B.
>
> Thanks in advance.
>
> Regds,
> Manish
>
> On Jan 25, 5:54 pm, Paul Schreiner  wrote:
>
>
>
>
>
> > Is column B "selectable"?
>
> > (When setting protection, it is possible to protect the cell
> > from changes, yet allow the user to select the cell)
>
> > If it is, then you can use a Selection_Change event
> > and check:
> > If (Target.Column = 2) then
>
> > within the event, you can open the userform.
>
> > You'll be able to make changes to other cells,
> > but to make changes to column B, you'll have to
> > know the password and unprotect the sheet.
>
> > Paul
>
> > 
> > From: Manish 
> > To: MS EXCEL AND VBA MACROS 
> > Sent: Tue, January 25, 2011 1:37:03 AM
> > Subject: $$Excel-Macros$$ User form value in current active row
>
> > Dear Excel Experts,
>
> > Can you please suggest me the code for following task.
>
> > My sheet is password protected and Column B is locked. When user try
> > to enter the data in any cell of column B, I want to open one user
> > form.
> > I am comfortable with build the user form. In my user form I have six
> > TaxtBox, I want to write the data of user form in same sheet active
> > row column C to H.
>
> > I know the write the user form data in new worksheet, but I don’t know
> > the code to write the data in active row and also the code for open
> > the Userform, if my cell is locked.
>
> > Pls help.
>
> > Thanks in Advance…
>
> > Regds,
> > Manish Pansari
> > +91 9810 88 8281
>
> > --
> >--�-­---
> >-
>
> > 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. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > Like our page on facebook , Just follow below
> >linkhttp://www.facebook.com/d

Re: $$Excel-Macros$$ User form value in current active row

[Paul Schreiner]

I've got a macro running right now, so I cannot test the code, but I can 
describe it!

Right-click on your sheet name "tab" and select "View Code".
In the VBA editor panel, in the Top-left pull-down, select WorkSheet.
The "default" event may be the Worksheet_Change event
or the WorkSheetSelection_Change event.
If it's the Change event, use the right-hand pull-down to select
the SelectionChange event.

This macro will "trigger" whenever you select a cell on the sheet.

It passes the cell "range" as a variable called "Target".

Now, the issue here is that if you select more than one cell, 
the Target variable is an array instead of a single range.
So, I usually test it:
if (Target.count = 1) then

next,  test to see if the column of the cell is column "B"
If (Target.Column  = 2) then

You can save the Row number by using:
CurRow = Target.Row

Of course, within your userform macros, you can use ActiveCell.Row


Now, to launch your userform, use:  UserFormName.Show

Give that a try.
If you need more help, let me know and I'll write it when my  macro finishes.
(It's loading 600,000 records into an Oracle database.. it takes a while)

Paul




From: Manish 
To: MS EXCEL AND VBA MACROS 
Sent: Tue, January 25, 2011 8:10:47 AM
Subject: Re: $$Excel-Macros$$ User form value in current active row

Thanks Paul.
My column is selectable.
If user select/edit in the cell e.g. B3, i want to open the user form
and want to write user form value in same row i.e. row3 in column C to
H. And also i want to put total CtoH in column B.

Thanks in advance.

Regds,
Manish

On Jan 25, 5:54 pm, Paul Schreiner  wrote:
> Is column B "selectable"?
>
> (When setting protection, it is possible to protect the cell
> from changes, yet allow the user to select the cell)
>
> If it is, then you can use a Selection_Change event
> and check:
> If (Target.Column = 2) then
>
> within the event, you can open the userform.
>
> You'll be able to make changes to other cells,
> but to make changes to column B, you'll have to
> know the password and unprotect the sheet.
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Tue, January 25, 2011 1:37:03 AM
> Subject: $$Excel-Macros$$ User form value in current active row
>
> Dear Excel Experts,
>
> Can you please suggest me the code for following task.
>
> My sheet is password protected and Column B is locked. When user try
> to enter the data in any cell of column B, I want to open one user
> form.
> I am comfortable with build the user form. In my user form I have six
> TaxtBox, I want to write the data of user form in same sheet active
> row column C to H.
>
> I know the write the user form data in new worksheet, but I don’t know
> the code to write the data in active row and also the code for open
> the Userform, if my cell is locked.
>
> Pls help.
>
> Thanks in Advance…
>
> Regds,
> Manish Pansari
> +91 9810 88 8281
>
> --
>---­---
>-
>
> 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. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
>linkhttp://www.facebook.com/discussexcel

-- 
--

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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ User form value in current active row

[Manish]

Thanks Paul.
My column is selectable.
If user select/edit in the cell e.g. B3, i want to open the user form
and want to write user form value in same row i.e. row3 in column C to
H. And also i want to put total CtoH in column B.

Thanks in advance.

Regds,
Manish

On Jan 25, 5:54 pm, Paul Schreiner  wrote:
> Is column B "selectable"?
>
> (When setting protection, it is possible to protect the cell
> from changes, yet allow the user to select the cell)
>
> If it is, then you can use a Selection_Change event
> and check:
> If (Target.Column = 2) then
>
> within the event, you can open the userform.
>
> You'll be able to make changes to other cells,
> but to make changes to column B, you'll have to
> know the password and unprotect the sheet.
>
> Paul
>
> 
> From: Manish 
> To: MS EXCEL AND VBA MACROS 
> Sent: Tue, January 25, 2011 1:37:03 AM
> Subject: $$Excel-Macros$$ User form value in current active row
>
> Dear Excel Experts,
>
> Can you please suggest me the code for following task.
>
> My sheet is password protected and Column B is locked. When user try
> to enter the data in any cell of column B, I want to open one user
> form.
> I am comfortable with build the user form. In my user form I have six
> TaxtBox, I want to write the data of user form in same sheet active
> row column C to H.
>
> I know the write the user form data in new worksheet, but I don’t know
> the code to write the data in active row and also the code for open
> the Userform, if my cell is locked.
>
> Pls help.
>
> Thanks in Advance…
>
> Regds,
> Manish Pansari
> +91 9810 88 8281
>
> --
> ---­---
>
> 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. Excel tutorials athttp://www.excel-macros.blogspot.com
> 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below 
> linkhttp://www.facebook.com/discussexcel

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ User form value in current active row

[Paul Schreiner]

Is column B "selectable"?

(When setting protection, it is possible to protect the cell 
from changes, yet allow the user to select the cell)

If it is, then you can use a Selection_Change event
and check:
If (Target.Column = 2) then

within the event, you can open the userform.

You'll be able to make changes to other cells,
but to make changes to column B, you'll have to 
know the password and unprotect the sheet.

Paul





From: Manish 
To: MS EXCEL AND VBA MACROS 
Sent: Tue, January 25, 2011 1:37:03 AM
Subject: $$Excel-Macros$$ User form value in current active row

Dear Excel Experts,

Can you please suggest me the code for following task.

My sheet is password protected and Column B is locked. When user try
to enter the data in any cell of column B, I want to open one user
form.
I am comfortable with build the user form. In my user form I have six
TaxtBox, I want to write the data of user form in same sheet active
row column C to H.

I know the write the user form data in new worksheet, but I don’t know
the code to write the data in active row and also the code for open
the Userform, if my cell is locked.

Pls help.

Thanks in Advance…

Regds,
Manish Pansari
+91 9810 88 8281

-- 
--

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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel

-- 
--
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. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel