selection values

  1. M

    How to copy selection.address cell values to another workbook.?

    hi, I am new to VBA and tryin to reduce some workload to make a small VBA program to copy range randomly with mouse and paste it to destination file. source file is "Mytest.xlsm" and destination file is "BatchEntry.xlsx" I can easily copy range by below code and successfully paste It to other...
  2. N

    Excel drop down selections x2 with outcome in third box.

    Hi, I have put together a table with roof pitch (0.5-30 deg) along the top and roof area (5-800m2) down the side, these are my two variables that I would like to select in two separate drop down menus. Based on the selection of roof pitch and roof area selected in these two drop down menus, I...
  3. F

    Paste values from listbox below ActiveCell

    hi, I have listbox. When user select item and click add, the value should be add to sheet: one row below where the current field is selected. 'Set addme = 'missing code For x = 0 To Me.lbsourceList.ListCount - 1 If Me.lbsourceList.Selected(x) Then...
  4. J

    Running a code based on mouse selected range?

    Hello - I am trying to figure out how to run a code based on multiple cells selected by mouse. I have been trying some basics to figure it out with no success: Sub Color_Green() Application.ScreenUpdating = False Dim Ac As Range Dim a, b As Long With ActiveSheet Set Ac.Range =...
  5. J

    Using defined cells in macro coding

    Hey Guys, im using macro coding and trying to use a defined set of values in a code. so i selected a set of values and defined the name as expansion and this is how i wrote the code Sub Hide_cells() ' ' Hide_cells Macro ' '...

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