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-wi
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 stri
ul 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 Fo
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 wi
ate: 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 any
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
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 w
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
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
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.noorai
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 w
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
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, 2
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,*
>
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 P
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:* Suryap
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
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,
>
> Ne
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
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
rom 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, Februar
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.
>
>
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
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 userfo
t;
> 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
>
XCEL 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 a
erform, 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
>
>
> Fro
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 ce
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
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
30 matches
Mail list logo
