This is related to a different question I asked about getting exact position on a sheet of a option box but I have made it a separate question in case it can be applied to other objects and therefore perhaps help others.
Admin please delete if you feel this question is not appropriate.
I am using Excel 2007
Is there a way of seeing or getting the exact position coordinates of a object on a worksheet, maybe a macro that can return or display the coordinates into a cell or on the clip board?
The object is a option box called "OptionBox1"
What I mean by exact position is the...
I have the following code in a macro that creates sets the value of Cell B25.
If Range("B23").Value = 2 Or Range("B23").Value = 3 Or Range("B23").Value = 4 Or Range("B23").Value = 5 Then run code
<run code="">This works well but I now need it to do the following so it runs different code...
hi all members,
i was wondering how i may change column (F) to (G) and the same thing with column (H) and (I)
(I)data with formula
I have a macro that works in printing out the requested fields for all items on a drop down list. It determines if there is any values on the second page then prints out just one or both pages depending on what is returned. I am trying to adjust it so it saves as PDF rather than prints...
What I am looking for is impossible permutation combination I have been on this for sometime and cant seems to wrap a Excel vba around it. here goes.
I have 5 columns each have a list of names( max limit of names per column is 50)
First column a list of fruits
Second column a list of...
#2[/URL] 42729]I have an excel file with a template to write it in Notepad with certain format,
#2[/URL] 42729]And the Output in notepad is,
#2[/URL] 42729]Below is the code which I tried and also got help from stack overflow, but I am not able to compose the...
Still learning Ms Access vba but learning fast.
I am not understanding fully and I am stumped on just on two things of which I am sure solve one, the other will also be solved. Spent the last 2 days with no progress. :(
I have a button on my form opening my excel spreadsheet (template)...
Hello all, I am trying to figure out the VBA to replace all negative values in a specific range, on a specific worksheet "MonteCarlo", Range "S3:AMD163". I have tried unsuccessfully couple of times with the following code:
Amy help from a more seasoned VBA writer would be appreciated!
Can you suggest any VBA code which will delete the cells with no data entries. I also want it to remove the 24 x hourly periods plus the date cell which is 24 merged cells. I hope you can copy and paste sp you can see the formatting.
Period 1 could have a min of 3 days of data (6 empty...
I update a spreadsheet to record hourly average service response time through a 24hr period. Once the data is entered this can leave a number of days without any data entries. In the example below this would be from 24-1 of 8/11/2017. I run a macro which does a lot of formatting that had...
I'd like to change the x-axis with values from the table to generate a Gantt chart.
I have no problems to create a chart with for example a range from calendar week 20-51.
<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height...
I have a macro-enabled workbook and I would like to disable the Save and save as option in the workbook to prevent users from creating local copies of the same.
I used the following code in Thisworkbook,
<code class="vb keyword" style="white-space: nowrap; font-size: 1em !important...
I need 5 horizontal cells to automatically fill in based on the information that might be in 10 vertical cells without the 5 horizontal cells duplicating.
The link will take you to my dopbox where you can download a...
I am new to this forum hoping someone could help.
I have an excel like below
A B C
Man_is Human Man
Women_if Human Cat
I need to find the words from column C matched against Column A...
Sometimes (usually) I can't open multiple Excel workbooks at the same time. Sometimes (not often) I can. I try double-clicking on the file(s); right-click/open; etc. Nothing seems to work consistently.
When I have BookA open, I have to close it before can open BookB.
I "think" this started...
I have been referring to this forum quite a fair bit recently to learn about Excel Macro from fellow experts in here. And for that, I want to thank you all first.
I have also referred some threads related FormulaArray too... which comes to the main reason of this thread.
I know that...
hi every one i have file which has data of last 30 days but it have to extract data daily of last 15 days from current day. now i am manually putting the dates of last 15 days and using vlook up to match but i guess there is another way through VBA . the data is in column A. Any one please...
I have 2 sheets named orange book data alerts and total orange book data alerts , both sheets have data from A to M, unique value is in Column A in both the sheets. here I compare orange book data alerts with total orange book data alerts. When there is a match, compare its row cell values for...