Are you still looking for a way to extract attributes from your drawings into an Excel file?
If so, thanks to alot of hard work on the part of some people at VBA design forum and a lot of headaches and sweating blood I have an Excel macro program that works on what seems to be from R14 through...
Hi all:
Does this look like a big Problem and can anyone help???
I am trying to access multiple blocks for the information that is contained in the attributes, pull them out of the drawing or set of drawings and store to an Excel file. As a VERY NEWBIE in VBA I haven't had much luck in working...
RTyndall:
I have a copy of a program that I use for testing small applications like this that I can send you. The ability to select one of the items from the list along with the list itself has been modified to include a temp. array. My e-mail is mike.norbury@fmcti.com, drop me a line and I'll...
Mike,
It works great. I also found out over the weekend that if I change the .Select at the end of the Sheet line to .Activate I get the same results. It took a while to adjust the rest of the program but I now have 11 sheets hidden behind my main cover sheet and all accessable and sharing...
Put this in the gen declarations of a user form (UserFrom1)
Add the list box and two OptionButtons and put a little value into several cells in column A of the two sheets.
Private Sub OptionButton1_Click()
Sheets("sheet1").Select
UserForm1.ListBox1.Clear
Call...
Mike,
That would not work as each sheet contains a seperate listing of information that is not related to the other sheets. All information in each sheet is expanding based on individual input from multiple user forms and the expansion is at different rates.
I do however need to hide these...
Mike,
I got it. [bigcheeks]
I added
Set Sheet = Application.ActiveSheet
changed your (with) to
with sheet
added
UserForm1.ListBox1.Clear
just before calling for FillList_NoBlanks
in button (Click)
I Hope It's right, it works
Thanks again
Is there anyone who deals with VBA in Excel that can tell me how to access selected values of attributes based on name and/or layer and list in Exel. It will work as a BOM start to combine what is in my drawings with my database of company parts and numbers. I know a small amount of VBA...
Mike,
One last small bit is that each of the "9" option buttons on the form activate a different sheet to bring a list up in the same listbox while the userform is still showing.
Can I use the refresh command at button click to bring the new list in from the new sheet??
mike
Mike,
That is just what I was looking for, now if I can figure out the Dims and outs as needed I will be in great shape.
I have the Excel 2002 programing book but at times it's a little vague or short in explanation.
Again
Many Thanks
Hello People,
I am new to the world of vba and am trying to get a list or combobox to display a variable range of information from say A2 to end. The problem is that there are blank cells in column A between those I need for listBox and I Don't want Them, just those cells with a value. Also...