Dear Sir / Madam,
Please see the attachment. There could be thousand clients with their
banks. I want wnen I put the client name in the column a, there will be
dropdown list in the column B. All the bank name will be shown in the
dropdown list of correspondence client name
Thanking you in
Thank you sir, will create button as per your suggestion.
2014-06-29 20:32 GMT+05:30 Vaibhav Joshi v...@vabs.in:
Hi
You can create a button on main sheet to run macro. Create button or image
and right click on it to assign macro.
Cheers
On Jun 29, 2014 5:43 PM, Vijayendra Rao
my first suspicion is that your 2010 application hasn't been set to trust the
VBA object model.
Because just about everything in 2007 is available in 2010.
but your error seems to imply a permission to create a userform object.
for which you would need to VBA trust setting set.
Look at:
Dear Vabz,
Apology for the late response, as i was trying to solve some issues with
the code by myself, but sadly i did not get very far.
The logic is great but the macro only seems to works on that sample_input
worksheet, as I tried to copy the macro onto new worksheet (please see the
new
PFA
It might help you.
On Mon, Jun 30, 2014 at 4:17 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Dear Sir / Madam,
Please see the attachment. There could be thousand clients with their
banks. I want wnen I put the client name in the column a, there will be
dropdown list in
To use the code for another sheet, you add 2 lines of code on the start and
end Module.
With ActiveWorkbook.Worksheets(Sheet1)
End With
Sheet1 is the name you need to reference sheet.
For example:
Sub SortAscendingD_Sheet1()
With ActiveWorkbook.Worksheets(Sheet1)
Rows(7:2000).Select
Dear lalitji
code not working
On Tue, Jul 1, 2014 at 8:00 AM, Lalit Mohan Pandey
mohan.pande...@gmail.com wrote:
I have checked it and it is working fine but give a try to this code:
Sub SECEPSDES()
With ThisWorkbook.Worksheets(Sector Valn)
.Sort.SortFields.Clear
Dear Bé Trần Văn
Code is good but required data sort each column but code sort data on
basis of D7 cell only ,if i want sort it another column then need to
change cell numbers each time then work done in some time.
Can we give as header row No 6 as ascending descending then we can
sort data with