dear mr. takyar, i have been following your chanel for some time and have lots of inspiration from this. at the moment i am stuck wirth a problem! i need to sort 2 columns which are dependant on other. for example column a, cell a1 contains the english word "agile" , column b, cell b1 contains the german translation "agil". there are many many rows (over 500) each with unsorted words in column a und the translation in column b. the column a needs to be sorted, complete with the column b, which contains the transation, automatically. could this be be possible with just a formular? the use of a macro or other vba code? kind regards, colin huntley
This is a great video! It makes understanding dictionary basics very easy. If I have a table in another workbook or worksheet that has a column of keys and a column of items, is there a way to look at those columns and add all the items to the dictionary dynamically?
I created macro for to open different work book and it executed but my workbook opened including my original file location, ex: i saved as Book1 it shows in workbook top name as book1-c:/my path also, how can i remove that, kindly suggest.
@@Exceltrainingvideos Hello sir, here is my code.. Sub input ( ) Dim fso as object Set fso = vba. Createobject("scripting. Filesystemobject") i = GetFolder () Workbooks("Mymacro. xlsm").sheet("main").Range(a1).value = i Application.caption = Thisworkbook. Path Source = Thisworkbook. Path & "\support\input.xlsx" Destination = workbooks ("Mymacro. xlsm").sheets("main").range("A1").value & "\input. Xlsx" End sub The purpose of the macro is. When i click the macro it will ask for the destination and if the destination selected it will give one input excel which is already available in support folder there people need to update their information. For that only the excel sheet shows file destination with the file name.
sir i creat a worksheet like saving account . money withdrawals and deposit . and i also creat a user from to manage this worksheet. i want when i enter withdrawals amount greater than available balance. than user from show error massage not avilable balance when i submit this through user from . plz help me sir what code i use for this. thanks in advance
We assume the balance is in column 3: Private Sub CommandButton1_Click() Dim lastrow As Long lastrow = Sheet1.Cells(Rows.Count, 3).End(xlUp).Row If Val(TextBox1.Value) > Sheet1.Cells(lastrow, 3) Then MsgBox "Available balance is less than withdrawal amount!" End If End Sub
These links will guide: www.exceltrainingvideos.com/place-picture-in-excel-worksheet-cell-using-vba/ www.exceltrainingvideos.com/insert-picture-in-multiple-worksheets-automatically/
dear mr. takyar, i have been following your chanel for some time and have lots of inspiration from this. at the moment i am stuck wirth a problem! i need to sort 2 columns which are dependant on other. for example column a, cell a1 contains the english word "agile" , column b, cell b1 contains the german translation "agil". there are many many rows (over 500) each with unsorted words in column a und the translation in column b. the column a needs to be sorted, complete with the column b, which contains the transation, automatically. could this be be possible with just a formular? the use of a macro or other vba code? kind regards, colin huntley
Marvelous Dinesh. Hat tip to you.
Glad you found the video useful. Thanks for the feedback.
Useful video
Glad you liked it! Please share the Excel VBA tutorial with your friends too.
dear mr. takyar, i have been following your chanel for some time and
have lots of inspiration from this. at the moment i am stuck wirth a
problem! i need to sort 2 columns which are dependant on other. for
example column a, cell a1 contains the english word "agile" , column b,
cell b1 contains the german translation "agil". there are many many rows
(over 500) each with unsorted words in column a und the translation in
column b. the column a needs to be sorted, complete with the column b,
which contains the transation, automatically. could this be be possible
with just a formular? the use of a macro or other vba code?
kind regards,
colin huntley
Will work on this problem.
This is a great video! It makes understanding dictionary basics very easy. If I have a table in another workbook or worksheet that has a column of keys and a column of items, is there a way to look at those columns and add all the items to the dictionary dynamically?
You can try using the 'path' to the values.
Thank you! I will give that a try.
I created macro for to open different work book and it executed but my workbook opened including my original file location, ex: i saved as Book1 it shows in workbook top name as book1-c:/my path also, how can i remove that, kindly suggest.
Can you share your code here?
@@Exceltrainingvideos
Hello sir, here is my code..
Sub input ( )
Dim fso as object
Set fso = vba. Createobject("scripting. Filesystemobject")
i = GetFolder ()
Workbooks("Mymacro. xlsm").sheet("main").Range(a1).value = i
Application.caption = Thisworkbook. Path
Source = Thisworkbook. Path & "\support\input.xlsx"
Destination = workbooks ("Mymacro. xlsm").sheets("main").range("A1").value & "\input. Xlsx"
End sub
The purpose of the macro is.
When i click the macro it will ask for the destination and if the destination selected it will give one input excel which is already available in support folder there people need to update their information.
For that only the excel sheet shows file destination with the file name.
Buen vídeo como siempre
Thanks for the feedback!
sir i am creat a userfrom in vba . i want when i enter greater than vallue a specic cell than msg show "insaffisant balance " how to possible this ??
I replied to your query earlier.
sir i creat a worksheet like saving account . money withdrawals and deposit . and i also creat a user from to manage this worksheet. i want when i enter withdrawals amount greater than available balance. than user from show error massage not avilable balance when i submit this through user from . plz help me sir what code i use for this. thanks in advance
We assume the balance is in column 3:
Private Sub CommandButton1_Click()
Dim lastrow As Long
lastrow = Sheet1.Cells(Rows.Count, 3).End(xlUp).Row
If Val(TextBox1.Value) > Sheet1.Cells(lastrow, 3) Then
MsgBox "Available balance is less than withdrawal amount!"
End If
End Sub
PLZ MAKE A VIDEO ON HOW TO INSERT PICTURE FROM USERFORM TO CELL NEXT STUDENT NAME.
PLZZZZZ
PLZZZZZZZZZZ
These links will guide:
www.exceltrainingvideos.com/place-picture-in-excel-worksheet-cell-using-vba/
www.exceltrainingvideos.com/insert-picture-in-multiple-worksheets-automatically/
Do we not need to add Scripting Dictionary from Reference?
In the early binding mode - yes. In the late binding mode you don't nrrd tp do that. You can create the 'object' at runtime.
@@Exceltrainingvideos Thanks al ot Mr Katyar.
sir please beginning to advanced vba learn video step step uploaded. please sir
You can start here: www.exceltrainingvideos.com/excel-vba/excel-2003-vba/
dear mr. takyar, i have been following your chanel for some time and
have lots of inspiration from this. at the moment i am stuck wirth a
problem! i need to sort 2 columns which are dependant on other. for
example column a, cell a1 contains the english word "agile" , column b,
cell b1 contains the german translation "agil". there are many many rows
(over 500) each with unsorted words in column a und the translation in
column b. the column a needs to be sorted, complete with the column b,
which contains the transation, automatically. could this be be possible
with just a formular? the use of a macro or other vba code?
kind regards,
colin huntley
Will work on this problem.