#vba #excel #pleasehelp

  1. K

    How get data From Table to Combobox x using VBA coding

    ***How get data From Table to Combobox x using VBA coding ? i was trying to Get data From Sheet1 "Table1" data to Sheet2 Combobox 1.......... When i select party name after reflect Address in (Range A8:A10) As per (BILL TO PARTY DATA), And At time Reflect "Ship To Party" Name & Address...
  2. K

    I was try to load data To List Box And Transfer data to Sheet2.... (Not work this userform)

    My Userform not working to my VBA coding As per below Private Sub TextBox2_Change() End Sub Private Sub TextBox3_Change() End Sub Private Sub UserForm_Initialize() ' Initialize Sr. No. to 1 when the form loads TextBox1.Text = 1 ' Populate Combobox1 with Product Names from...
  3. K

    How to Transfer Data To Table and Fill in Invoice ?

    WE NEED DATA TRANSFER TO TABLE AND EASY DATA ENTRY ........... SO I WAS FAILLED... I Don't know how to write vba coding As per my Question DATA Range : J7:MJ Table Range : C7:C24
  4. K

    How to macro will Unhide all the worksheet except the active sheet

    'This macro will hide all the worksheet except the active sheet Sub HideAllExceptActiveSheet() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets If ws.Name <> ActiveSheet.Name Then ws.Visible = xlSheetHidden Next ws End Sub This code its working But We need 'This macro will Unhide all...
  5. K

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also ? how its possible on VBA coding ???

    We need only Visible,"Deskboard" Sheet, When I click Deskboard After Hide All other sheet Also, I will Making Purchase Order Tracking System I was Jump Sheet Using Hyperlink Also. Pleased Need VBA Coding When I click Deskboard After Hide All other sheet Also = "Deskboard" Sheet is Trigger...
  6. K

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding

    When I Click cell C8, I should see the command button shown in E8 not otherwise via vba coding. i was follow this code but not working pleased help me : Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Me.Range("C8")) Is Nothing Then...
  7. K

    #how to using Combo box1 to Range A2:A8 ??? and i will increase & decrease cell size at time auto set Combo box size As per cell ?

  8. K

    #When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. (VBA)

    When "ITEM LIST" is selected in the range in particular cell, the HYPERLINK should be visible on the side. *My Hyperlink click and Jump Sheet 2 "Table 2" (Table 1 location = Sheet 1) My TABLE NAME IS = "Table 1" Range name (B3:B8) = "ITEM_LIST" How to possible This Query ??? Kindly Share...
  9. K

    When the item-list is selected in the range in particular cell, the Shape button should be visible on the side.

    When the item-list is selected in the range in particular cell, the Shape button should be visible on the side. How it possible to make this hyperlinkbutton in table
  10. K

    How to Fill Data Entry via Userform in Table 1 ???????

    Option Explicit Private Sub cmdSave_Click() Dim LR As Integer, Master As Worksheets Set Master = ThisWorkbook.Worksheets("Master") LR = Master.Cells(Rows.Count, "A").End(xlUp).Row If LR = 2 And Cells(LR, "A").Value = "" Then LR = LR Else LR = LR + 1 End If Master.Cells(LR...
  11. A

    Copying a range containing cells that meet a criteria & pasting into a different sheet

    Hi all! Basically like the title states, I need some help with writing a code that can 1. copy a range of rows that meets the criteria, and then 2. paste it into a range into another sheet. 1. In Sheet "Food Restrictions", there is table that ranges from B4:H1000 (1000 is a general...
  12. K

    how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink)

    how to make hyper link Button ?? when i click down in cell with show "Add New " Button (button is hyperlink) This Invoice Product name Combo box with show Hyper link button appears Out side the combo box, how to possible pleased Need this vba code , (Condition : How to fix same place in range...
  13. Z

    VBA CODE HELP

    Need some help with a code that lets me clear contents for a cell that is over a year old, then also clears the contents on the remaining row until a certain point. The first cell in the row will have the date, and the next two cells will have data that needs to be cleared, adn the rest of the...
  14. Z

    Applying SUMIF Formula in Multiple Sheet with VBA

    Hi guys, i need some help. maybe you can help. i have 4 sheets, first sheet as a Master Sheet. second until fourth sheet act as a slave sheet. Whenever there are any change in "sold" column in slave sheets, it will fill and affect the amount in "sold" 's column in Master Sheet based on criteria...
  15. K

    How to Highlight Cell After match Both data ???

  16. K

    HOW TO LOCK COLUMNS ??? (we need Lock Highlight Columns)

    @ HOW TO LOCK COLUMNS ??? I try Column " A" & "B" FIX & Lock ....... This "HSN CODE " IS EVERY TIME FIX & SAME IN BILL ......... Problem : 5 and more people use this File, So my was Change every time , i tried ... We Need lock Columns lock trick .. pleased solve my Query.
  17. K

    Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

    i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????
  18. E

    Issue with opening multiple files via a file name list via VBA

    Hi guys! Hope you are all well! This is the first time I try this forum, so please do let me know if I didn't do something correctly. Also, I am a self taught VBA noob, so it would be greatly appreciated if you can please dumb it down as much as possible in the explanation/code. Thanks heaps...
  19. C

    Need to copy from sourcesheet to destination sheet only the new data entered based on serial no on the source sheet

    I am totally new to Excel VBA. But I have a requirement to copy some data from let us say sheet1 to sheet2. I have several columns and rows in sheet1 (source sheet). Now I have to copy only Five columns data from within that where "Ferro Manganese" found in particular one coloum and if found...
  20. L

    VBA loop through multiple sheets, if value greater =>12 then copy row to combined sheet

    hey Guys I am having issues with my code. Originally (see original code) I would loop through all sheets and combine data in to one. This worked great. Only 1 sheet had headers (data spill). 'Original code For i = 2 To Sheets.Count Set xRg = Sheets(1).UsedRange If i > 2 Then...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top