Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 24 of 24
Search took 0.01 seconds.
Search: Posts Made By: aspadda
Forum: Excel VBA April 23rd, 2004, 12:59 PM
Replies: 0
Views: 914
Posted By aspadda
Trying to avoid duplicacy

A) I have a file with two forms and a bunch of data in it.

B) I have around 50 odd more templates.

I need to attach A) with all 50 templates (B).

I am looking for a way to centrally...
Forum: Excel VBA March 19th, 2004, 04:06 PM
Replies: 2
Views: 15,249
Posted By aspadda
Thanks for your reply. Your are perfectly correct...

Thanks for your reply. Your are perfectly correct what you mean. But i want to use this option for programming VBE. And this is only in excel 2002 that you need to check this option to programme VBE...
Forum: Excel VBA March 18th, 2004, 03:25 PM
Replies: 2
Views: 15,249
Posted By aspadda
Programmatic access to Visual Basic Project is not

I have a template which i need to distribute to unknown number of audiance. If "Programmatic access to Visual Basic Project is not trusted" is not checked manually, i get the following error :...
Forum: Excel VBA March 17th, 2004, 10:37 AM
Replies: 0
Views: 1,755
Posted By aspadda
Print Preview problem

I have a template with forms, data(in worksheet) which gets me an output (in another worksheet) depending on the questions asked on the forms. When user hits the done button ...before the form closes...
Forum: Excel VBA March 17th, 2004, 09:27 AM
Replies: 2
Views: 968
Posted By aspadda
Output Size

I have a VBA template (Little Less than 1 MB) . Template contains a worksheet (1) which contains data and i have couple of forms with listboxes etc which pick the data from the worksheet (1) and...
Forum: Excel VBA February 25th, 2004, 03:48 PM
Replies: 0
Views: 1,632
Posted By aspadda
Row Height

I have a cell(merged)-(lets say cell-1) which is being fed from the input from the form. In the excel sheet i have around 20 cells (some of them merged) which references to the cell-1. To all the 20...
Forum: Excel VBA February 23rd, 2004, 11:57 AM
Replies: 2
Views: 1,427
Posted By aspadda
Frame Index

Here is a situation : I have a form with multipage control (Multipage has 6 pages). On each page i have 2 frames. I want to access the frames (through code) in a sequence (for eg : page1.frame1 and...
Forum: Excel VBA February 20th, 2004, 10:12 AM
Replies: 6
Views: 29,316
Posted By aspadda
I am also doing the same thing...but is there a...

I am also doing the same thing...but is there a way to get away with cross icon on the right hand side top.

Thanks

Ajitpal S Padda
Forum: Excel VBA February 16th, 2004, 04:47 PM
Replies: 6
Views: 29,316
Posted By aspadda
I happen to read this topic while searching for...

I happen to read this topic while searching for something else. I have a similar situation where i had restricted the the close event through code. I could'nt find a wayout in VBA to get away with...
Forum: Excel VBA February 16th, 2004, 04:39 PM
Replies: 0
Views: 799
Posted By aspadda
Restricting the forms to move

I have Forms on top of excel sheet..which drives few of the answers...i want to restrict the user to be not able to move the form. Could someone suggest a way out...

Thanks

Ajitpal S Padda
Forum: Excel VBA February 9th, 2004, 02:36 PM
Replies: 0
Views: 1,413
Posted By aspadda
Page Break

I have a excel template with froms...depending on the inputs on the forms it populates the excel sheet (Excel sheet has different sections setup). sometimes based on the selections a part of the...
Forum: Excel VBA January 29th, 2004, 03:02 PM
Replies: 4
Views: 6,848
Posted By aspadda
That's really strange.. I tried the same but wrap...

That's really strange.. I tried the same but wrap text text doesn't. work. Yes, if i dont have merged cells then wrap text works perfect. I m working with office XP. Meanwhile i shall try to find...
Forum: Excel VBA January 29th, 2004, 08:50 AM
Replies: 4
Views: 6,848
Posted By aspadda
Thanks for your reply. That works fine if the...

Thanks for your reply. That works fine if the cells are not merged. But i have merged cells and moreover it is a VBA application and i want to setup in a way that it should'nt be a manual way.


...
Forum: Excel VBA January 28th, 2004, 02:25 PM
Replies: 4
Views: 6,848
Posted By aspadda
Wrap text with merged cells

i have two merged cells in a row. I have set the wrap text property. But wrap text doesn't work. If it is not a merged cell wrap text works fine. Could some one help me with a way out to use wrap...
Forum: Excel VBA January 6th, 2004, 02:09 PM
Replies: 3
Views: 1,069
Posted By aspadda
Thanks Maccas!! That was real quick and worked...

Thanks Maccas!! That was real quick and worked perfect.

[8]

Ajitpal S Padda
Forum: Excel VBA January 6th, 2004, 01:10 PM
Replies: 3
Views: 1,069
Posted By aspadda
Offset Formulae

I have a set of data in a particular column. I have named a range with offset formulae as follows :
=OFFSET(Sheet1!$A$2,0,0,total,1)

Note : First row is the heading(not to be included in the...
Forum: Excel VBA December 18th, 2003, 12:43 PM
Replies: 1
Views: 1,660
Posted By aspadda
top row on the screen

I have a VAB Application in Excel. Excel worksheet has some controls (check boxes, comboboxes, optionbuttons, commandbuttons). What i m looking for is that on clicking a particular commandbutton, a...
Forum: Excel VBA November 26th, 2003, 11:11 AM
Replies: 2
Views: 1,725
Posted By aspadda
Though it did'nt solve my flickering problem but...

Though it did'nt solve my flickering problem but it was useful in speeding my desired tasks. THanks

Ajitpal S Padda
Forum: Excel VBA November 25th, 2003, 02:41 PM
Replies: 1
Views: 1,710
Posted By aspadda
Selecting a column

I have a excel sheet with 5 columns (A,B,C,D,E). I want to wite a macro to select column D and E and then change its font color. I have merged cells in Column A. What happens is that due to merged...
Forum: Excel VBA November 12th, 2003, 01:12 PM
Replies: 2
Views: 2,113
Posted By aspadda
declaring a public variable in module should be...

declaring a public variable in module should be fine..
Forum: Excel VBA November 12th, 2003, 01:07 PM
Replies: 0
Views: 1,786
Posted By aspadda
Copying controls at run time

Can anyone help me ,"how to copy controls (or lets say a frame with bunch of other controls in it) from one form to another at run time with code" (working on VBA excel forms)
Forum: Excel VBA November 12th, 2003, 01:04 PM
Replies: 1
Views: 2,053
Posted By aspadda
Though not sure but..i had also run across...

Though not sure but..i had also run across similar problem once....and i found out that what seems to be checkboxes were actually not checkboxes .....if you delete one and place another checkbox with...
Forum: Excel VBA November 12th, 2003, 12:56 PM
Replies: 2
Views: 1,725
Posted By aspadda
Modal Forms

I have two froms (showing one over the other, Excel VBA application). showmodal property for both is false(i want to see both of them at the same time partially overlapping). when i move from one...
Forum: Excel VBA November 11th, 2003, 03:40 PM
Replies: 0
Views: 1,233
Posted By aspadda
VBA Project Help

I have a situation...without database at all.
I need to design Excel VBA forms (for inputs) and based on the inputs it spits some stuff on the excel sheet. Now the problem is that i need to design...
Showing results 1 to 24 of 24

 


All times are GMT -4. The time now is 02:04 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.